list unique digits

hi excelers

I being trying to create a simple formula that only lists 3 UNIQUE digits from 5 digits (that may have repeats) - example:

5 Colums
1,1,2,3,2 = 1,2,3,

any comments, grateful for any solutions....

Not exactly sure what you want the result to be...but, here's a guess:

With
A1:E1 containing 3 unique digits....duplicates allowed...no blanks

This regular formula returns the 3 unique digits, in one cell, separated by commas:

Please Login or Register  to view this content.

If A1:E1 contains: 1 1 2 3 2
The formula returns: 1,2,3

Is that something you can work with?

I know this against the rules as I am adding nothing but...

WOW

Ron, very cool indeed... I have another of yours tucked away on a similar theme but that's very neat indeed.

Thanks for the kind words, DonkeyOte...much appreciated.

Here's a macro that will do what you want "on-demand". Install this into a standard module.

Please Login or Register  to view this content.

Now run the macro, it will ask you for a range of cells, select your range. Then it will ask where you want it, select a range of cells across one row and it will parse out the value for you.

I've tweaked the original code slightly since it was designed originally to return the values in a single column list, and you wanted them all in one row.

Originally Posted by stewart08

thanks ron indeed you know your stuff.

I used your the formula its work, but I need it to return 3 single digits in each colum...

OK...using the same set up of values in A1:E1

This formula returns the lowest of the 3 unique values:

Please Login or Register  to view this content.

Copy that formula across through G1:H1 for the 2nd and 3rd smallest values.

Does that help?