One way - lets say your data is in A2:A20. Enter this in C2

=MATCH(A2&" "&B2,A$2:A$20&" "&B$2:B$20,0)=ROW()-MIN(ROW(A$2:A$20))+1

and hit Ctrl+Shift+Enter (or you get #VALUE). Copy down. Then use the
autofilter and filter Column C for TRUE. Copy/paste the results of the
filter to D2. Turn off the filter, delete the formula in column C, and sort
the results in columns D and E however you wish.


"HDL" wrote:

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