extract unique values from list (UDF style)

Hi All,

Will be needing your help again.

Want: I need a UDF that will allow users to remove duplicates from the list (without using the remove duplicates function)

Note: Range is not fixed, since our data will depend on the number of active users.

Attached is a sample output.

Thanks in advance!

Use in cell like
=Uniq($A$2:$A$93,ROW(A1))
and copy down

To a Standard code module

Please Login or Register  to view this content.

well, as always, thanks for your awesome help Jindon!

its working!