View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HDL HDL is offline
external usenet poster
 
Posts: 3
Default 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