Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |