Excel Highlighting duplicates with exact matches

0 votes

I've got two columns of data, and I would like to use conditional highlighting to find the EXACT matches in both columns. However, using a formula like this one turns up a lot of incorrect matches:

=MATCH(A1,B:B,0)>0

There are a lot of partial matches, so cells are highlighted that I don't want. What I want is the equivalent of the "Match Entire Cell Contents" checkbox in the Find & Replace dialog.

But this only applies to find & replace. How can I update the formula above to work the same way, so that only exact matches to what's in a cell are highlighted?

Mar 23 in Database by Edureka
• 9,320 points
22 views

1 answer to this question.

0 votes

To enter the Advanced Filter dialogue box, go to the Data menu and pick Filter, then Advanced Filter. In the Action section, choose Copy To Another Location. In the Copy To control, choose a copy range. Select Only Unique Records and click OK.vba - Excel: Highlighting duplicates with exact matches - Stack Overflow

answered Mar 24 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer

how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
170 views
0 votes
1 answer

MS Excel - SumProduct formula with Loop

Drag this to the right of cell ...READ MORE

answered Mar 14 in Database by Edureka
• 8,820 points
22 views
0 votes
1 answer
0 votes
1 answer

Excel 2003 - Match Column A with Column B & Column C to correspond to Column B

Write a standard IF formula that compares ...READ MORE

answered Mar 15 in Database by Edureka
• 8,820 points
42 views
0 votes
1 answer

how do I calculate discount with if function in excel

Notes about the release; Frameworks to aim ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
25 views
0 votes
1 answer

Excel COUNTIF with multiple criteria and both row and column

Count Cells Based On Text Value Using ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
26 views
0 votes
1 answer

How can I calculate deciles with a range of 12,000 cells in excel?

1. Enter the following formula in cell ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
53 views
0 votes
0 answers

Why should I use the DIM statement in VBA or Excel?

So there is a question on what DIM is, but I ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
9 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP