Another one...

Assume your data is on Sheet1 A2:B20

Create this named range:

InsertNameDefine
Name: rng
Refers to:

=INDEX(Sheet1!$A$2:$A$20+(Sheet1!$B$2:$B$20/1000),,1)

Enter this formula in D2:

=IF(ROWS(D$2:D2)<=COUNT(1/FREQUENCY(rng,rng)),SMALL(rng,1),"")

Enter this array formula** in D3 and copy down until you get blanks:

=IF(ROWS(D$2:D3)<=COUNT(1/FREQUENCY(rng,rng)),MIN(IF(rngD2,rng)),"")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Enter this formula in E2:

=IF(D2="","",INT(D2))

Enter this formula in F2:

=IF(D2="","",MOD(D2,1)*1000)

Select E2 and F2 and copy down until you get blanks


--
Biff
Microsoft Excel MVP


"HDL" wrote in message
...
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