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

Highlight non-adjacent cells that have same content in three columns

Have worksheet with several columns and multiple rows where need to highlight cells that have same data as in other rows. Basically, if column A, B and G have identical information in rows 7 and 183, these cells will all highlight. Goal is to identify if the same sequence of data is present, in another row of the worksheet. I have used following formula previously:

=Countifs($A$7:$A$319,$A7,$B$7:$B$319,$B7)=1

However, I now need to innclude data that also appears same in column G.

Note: the data in each column is different,

Example:

Row: 7: Column A: ABCD, Column B: 1234, Column G: Foxy

Row: 183: Column A: ABCD, Column B: 1234, Column G: Foxy

This match would highlight, but if one data point differs, no match.

Hope someone can help here... Thank you.

submitted by /u/ThunderWarrior3
[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
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#row zero
#AI formula generation techniques
#Excel compatibility
#financial modeling with spreadsheets
#formula generator
#Excel alternatives
#highlight
#worksheet