eliminating duplicate lines

[JohnnyJomp]

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

 

[Tom Hutchins]

Two ways:

Use an advanced filter. Debra Dalgleish explains how clearly on her
excellent Contextures site:
http://www.contextures.com/xladvfilter01.html

Or, select all the data and create a pivot table with vendor as the row
field (you only have to go that far in creating it to get a unique vendor
list). After you finish creating the table, copy & paste it in place as
values.

Hope this helps,

Hutch

 

[Gaurav]

Select your list>go to Data>Filter>Advanced Filter>check Copy to another
location>check Unique records only>in Copy to box>type the cell address
where you want the list...say...D1>Ok

 

[JohnnyJomp]

Hutch and Gaurav: Thanks for the responses. I will have a look at how to
implement your suggestions.
John

 

[Bernd P]

Hello,

Or: My UDF lfreq
http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd

 

[GoBow777]

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

Hello John, check this out

+-------------------------------------------------------------------
|Filename: John.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=113
+-------------------------------------------------------------------