Unique values of a range

[Joe]

Anyone has an idea how to select the unique values of a
range (kinda select distinct) into a vector by using
worksheet functions ONLY (no VBA, no own addin, etc.)?

Joe

 

[Joseph]

Use Advanced Filter menu and in the dialog box that comes
up, "tick" the Unique Records only field

 

[Aladin Akyurek]

This discussion might be of interest...

http://makeashorterlink.com/?U119228B6