TK wrote:
Hi Jason:

"Jason@Simcon" wrote:

Boiled down the problem is this: from a column of 50, non sorted, entries
only 10 are unique, the rest are repetitions. Return in another column the 10
unique entries.


Is it me or does that not sound like an iimpressively simple problem to solve?


obviously not :)

John Walkenbach the author of the Bible, no not
that Bible, the Excel Bible has written a procedure
and made it available for download on his site.

http://www.j-walk.com/ss

search for "nodupes" without the quotes

Good Luck
TK

The procedure at the linked site, which uses a Collection to load a
ListBox, is about 8 or 9 times slower than using a Dictionary instead
for that purpose, and about 7 times slower than using the ArrayUniques
function, which I referred to earlier in this thread, for that purpose.

Alan Beban