troubleshooting Question

Excel help to identify duplicate values with a funciton or conditional format

Avatar of BajanPaul
BajanPaul asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
4 Comments1 Solution263 ViewsLast Modified:
Hello to all excel gurus,
I am trying to write a formula that will check 3 columns for duplicate data and return a "Duplicate" value.  I am hoping to do this with either a formula or conditional formatting.

The existing formula I have is as follows:
=IF(COUNTIF($B$1:$B1,B1)>1,"Duplicate","")

I know this will only identify duplicate values in one column, how do I expand the formula to include additional criteria.

Please see my attached excel file.

BP
Duplicates-Example.xlsx
ASKER CERTIFIED SOLUTION
Ken Butters

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros