Assuming these are columns A and B, how about this?

1) Sort both columns into numerical order
2) Insert/Name/Define and give the second column a name, e.g. Range1
3) In a column C column enter this formula

=IF(LOOKUP(A1,range1)=A1,A1,"")

Then copy the formula down column for as many rows as there are in
column A


--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=561103