Highlight non-adjacent cells that have same content in three columns
Our take
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience