'Highlight Duplicate Rows from 4 column with single row
I'm new for google sheet as well as excel but Please find the google sheet (i share it with editable) so you can edit also. So, my question is Ï want to highlight column A,B with Column D,E (for find duplicate) but don't want highlight row 3 and row 4 (it's duplicate but i want to highlight and compare between column A, with D and column B wit E.
Sorry for the poor English but hope you guys understand.
Solution 1:[1]
try:
=(COUNTIF($A$2:$A&$B$2:$B, $D2&$E2)>0)*($A2<>"")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |