| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making a list out of multiple duplicates
In Excel 2000 I'm at a bit of a loss on how to search a list in column A and
return all the unique matches to items in column B. Column A is already sorted in asending order. I want the resulting data to be in columns D and E without all the duplicates in column A. A B 120 143 120 93 120 143 120 143 160 118 160 143 160 118 160 143 160 293 170 118 170 143 170 168 170 218 170 118 170 168 170 218 170 118 170 168 170 218 The result should be; D E 120 93 120 143 160 118 160 143 160 293 170 118 170 143 170 168 170 218 I think I've read just about every post I could find and tried a few of the equations that I thought were close to what I want to have done, but I still can't quite get it. Any help would be greatly appreciated. HDL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Single list ~ not duplicates | Excel Discussion (Misc queries) | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| removing duplicates from a list | Excel Discussion (Misc queries) | |||
| Filtering a list with duplicates | Excel Worksheet Functions | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
Threaded Mode
