Solved

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

Posted on 2016-11-24
2
58 Views
Last Modified: 2016-11-25
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
Comment
Question by:John Ellis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 41900198
HI,

You could use conditional formatting with formula

=MATCH(A2,$B:$B,0)

Open in new window

Regards
0
 
LVL 33

Accepted Solution

by:
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
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…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question