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.
[link] [comments]
Want to read more?
Check out the full article on the original site