View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JohnnyJomp JohnnyJomp is offline
external usenet poster
 
Posts: 6
Default eliminating duplicate lines

Hi.
I have a spreadsheet of all my purchases. Each row is a separate purchase
and has the vendor name and other info. I would like to create a list that
shows each vendor name only once. I am not interested in the other data, just
a list of each vendor name. In effect, if I have 10 rows of purchases from
vendor abc and 5 from vendor 123, I want an alphabetical list that shows
vendors 123 and abc only once.
Any ideas?
Thanks
John