Solved

# Excel:  Comparing the Values in One Column with the Values in Another

Posted on 2016-11-24
49 Views
Hello:

In an Excel spreadsheet, let's say that Column A has values filled within rows 2 - 100.

Also, let's say that Column B has values filled within rows 2 - 48.  Some of the values in Column B match those within Column A, but some do not.

How can I highlight the values in Column A that match values in Column B?

Thank you!

John
0
Question by:John Ellis

LVL 49

Expert Comment

ID: 41900198
HI,

You could use conditional formatting with formula

``````=MATCH(A2,\$B:\$B,0)
``````
Regards
0

LVL 33

Accepted Solution

Norie earned 500 total points
ID: 41900203
John

Select the data in column A, goto Conditional formatting>New Rule... and select Use formula to determine which cells to format.

Enter this formula,

=NOT(ISERROR(MATCH(\$A2, \$B\$2:\$B\$48, 0)))

then goto Format... and select the formatting you want to highlight matches.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…