View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
solo_razor[_29_] solo_razor[_29_] is offline
external usenet poster
 
Posts: 1
Default extracting unique values with a formula or with vba


hello,

does somebody know how to find unique records in a column with a
formula or with vba code.
Example:
row d:
erik
paul
john
john
erik
paul
Richard
Richard
Amanda
John
john
erik
Amanda

Now the output schould be:
erik
paul
john
richard
amanda


Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/