comparing values

T

Thomas

Hello,

I would like to compare values in a excel spreadsheet. I want to have
it compare two columns that would be in scrambled order. For example:
If anything in column A equals anything in column B then place a
check in column C. Here is an example of what it could look like. I
appreciate any suggestions.

1 2
2 3 X
3 4 X
4 X


Thanks
Tom
 
B

Bob Phillips

Tom,

Put this formula in C1 and copy down

=IF(NOT(ISNA(MATCH(A1,B:B,0))),"X","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top