| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
eliminating duplicate lines
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 "JohnnyJomp" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
eliminating duplicate lines
Select your listgo to DataFilterAdvanced Filtercheck Copy to another
locationcheck Unique records onlyin Copy to boxtype the cell address where you want the list...say...D1Ok "JohnnyJomp" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
eliminating duplicate lines
Hutch and Gaurav: Thanks for the responses. I will have a look at how to
implement your suggestions. John "JohnnyJomp" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
eliminating duplicate lines
|
|
#6
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How am I able to del duplicate lines automatically | Excel Worksheet Functions | |||
| #N/A and eliminating it. | Excel Discussion (Misc queries) | |||
| Eliminating Duplicate GROUPS of Styles | Excel Worksheet Functions | |||
| How do you suppress duplicate lines? | Excel Worksheet Functions | |||
| Eliminating #N/A | Excel Worksheet Functions | |||
Linear Mode
