comparing two columns

C

campbellbrian2001

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
 
G

Gary''s Student

We can use conditional formatting:

say the data are in columns A & B

Select A1 and pull-down Format > Conditional Formatting...
Select Formula Is and enter:
=(COUNTIF(B$1:B$65536,A1)>0) and select a bright background color
copy this cell and paste/special format down the whole column

then

Select B1 and pull-down Format > Conditional Formatting...
Select Formula Is and enter:
=(COUNTIF(A$1:A$65536,B1)>0) and select a bright background color
copy this cell and paste/special format down the whole column


All the matches will be hi-lighted
 
C

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 
Top