Try this:Hi all,
I have a list in a column of names. I'd like to know how to use a function to search this entire list and print only the unique names in a new column.
Invoking SQL is a faster option (do a search on this forum), but here is another formula set up...Thanks very much.
That goes some way to fixing my issue. The list i'm dealing with has thousands of entries, and there are never going to be more than 50 different values (eg. names) in this list. If i copy that formula down from, say, B1:B50, it only looks at the A1:A50, but what I want is for the entire A column to be automatically consolidated into only the unique values, with no gaps or empty cells.
Is that possible? I know the Advanced filter does this perfectly, but i'm trying to design it so the user doesnt have to enter/do anything - it will be automated as soon as the data is copied in. Is there a function that carries out the filter?
Thanks very much
=IF(ROWS($C$3:C3)<=$C$1,INDEX($A$2:$A$12, SMALL(IF(FREQUENCY(IF($A$2:$A$12<>"", MATCH("~"&$A$2:$A$12,$A$2:$A$12&"",0)),Rvec),Rvec), ROWS($C$3:C3))),"")