1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to highlight if values in three columns match?

So I work for an insurance company and yesterday they found out that the system is somehow duplicating claims so they have about 10 people going through a spreadsheet to find spots where three columns match/have the same value. I've highlighted the person's ID number in red so we know to ignore the grey values since they're not duplicates so now I'm trying to figure out the best way to identify if the other values match each other.

So I need like an "if column A is equal to column B and column C highlight them or something of that nature." I'm not sure if Excel can do this. Thanks in advance.

If that's not clear I mean if values in all three fields are the same we're going through and marking them but this will take like 80 man hours or more and mistakes will be made.

submitted by /u/memento22mori
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#Excel
#duplicating claims
#columns match
How to highlight if values in three columns match?