Comparing 2 column for matches

I

IFIXPCS

I am wanting to compare 2 columns for exact matching. 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. Column C will be retrived in an random order... so how
would I write the formula for that?????

Example:
A B C
45time 11tune
A match 11tune 89time
47doog 43jkjkj
A match 123ABC 123ABC

If possible include how to highlight the ones that make as another option.
Thanks
 

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 list 4
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
Index/match across multiple columns? 16
Macro for comparing columns and highlighting matching/differences 13
Index and Match 5
compare 2 columns of numbers and place the matched numbers in a 3r 5
Remove Data which is not match with other column 1

Top