I need a little help with comparing columns and indicating the mat

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
 
B

bpeltzer

In cell A2: =if(isna(match(b2,c:c,false)),"","Match")
You could then use conditional formating: Format > Conditional Formating,
use the drop downs to make the condition Cell Value Is, Equal To, "Match",
then choose the format you want to use as a highlighter.
Copy cell A2 though the rest of column A.
 

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

I need to compare to columns and indicate the matches in another 1
Comparing 2 column for matches 0
Comparing 2 list 4
Macro for comparing columns and highlighting matching/differences 13
Comparing Text between Columns 6
Need a little help with a custom function 1
I need to set pointer to change a cell(s)with 1 click 0
I need to add an IF condition to a formula 9

Top