Comparing 2 list
Thank you for your reply. I don't know if this will help.. for example
column C can be in any order... so how would I write the formula for that?????
"bigwheel" wrote:
Based on your example data you bcould achieve this with the following:-
In cell A1, =IF(B1=C1,"A Match","")
If copied down the column, this will indicate all those cells which match
"IFIXPCS" wrote:
I have read through alot of problems here in the forum but none have answered
mine.
I am wanting to compare 2 columns for exact matching (ex. "Green32"). And
if there are two matching items I want to be able to say "A match" in a
chosen cell for all the ones that match.
Example:
A B C
45time 89time
A match 11tune 11tune
47doog 43jkjkj
A match 123ABC 123ABC
please help!!
Thank you in advance!
|