Comparing 2 list

I

IFIXPCS

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!
 
B

bigwheel

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
 
I

IFIXPCS

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?????
 
I

IFIXPCS

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?????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing 2 column for matches 0
I need to compare to columns and indicate the matches in another 1
I need a little help with comparing columns and indicating the mat 1
Comparing different length columns 3
comparing 2 columns 6
Compare two cells in two different files and return answer 6
Compare data from two different worksheets with a condition 2
Comparing Cells 1

Top