By atkachov4@gmail.com on Monday, 05 February 2018
Posted in Kutools for Excel
Replies 1
Likes 0
Views 5.8K
Votes 0
Hello All,

I'm trying to do massive data which has to be filled with set of custom numbers but in each row any number should be used only once and this massive should have length of the row from 5 numbers.

Example:
Set of numbers: 10, 27, 23, 30, 37, 49, 17, 43, 5, 14, 19, 26, 28, 9, 20, 21, 44, 48, 1, 2,

Right result example: 10, 27, 23, 30, 37 (all numbers are unique)
Wrong result example: 10, 27, 23, 10, 37 ( 1 or 2 or more duplicates in a row)

Can you help please.
Thanks in advance.
Hello,
Sorry, we don't have such function yet.
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post