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

Our take

Are you looking to highlight non-adjacent cells across multiple columns that contain identical data in your spreadsheet? In a scenario where you want to identify rows with matching sequences, such as those in columns A, B, and G, you can enhance your existing formula. For instance, if rows 7 and 183 both contain "ABCD" in column A, "1234" in column B, and "Foxy" in column G, you want these cells to be highlighted. Let’s explore how to adapt your formula to achieve this goal effectively.

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]

Read on the original site

Open the publisher's page for the full experience

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