In C1 put this formula and copy down.....

=IF(ISNA(VLOOKUP(B1,A:A,1,FALSE)),"","<")

Vaya con Dios,
Chuck, CABGx3



wrote in message
oups.com...
I have a spreadsheet in Excel 2000 that has two columns. Basically I
want to find out which of the lesser-number-of-numbers columns has a
matching number in the larger-number-of-numbers column. It would look
like this

A B
-------- --------
1561465 1561465 <
1654345 4564343
1545485 8452154 <
8452154 1454654
1654652 1365145
1546848 8545212
9546531 2584521
6543546 1564654
5452133 2154542
1777754
8959599
9546531 <

Thanks! for anyone's help

BrianCampbell