Search code examples
if-statementgoogle-sheetsduplicatesconditional-statementsconditional-formatting

I need a way to find duplicates only when occur simultaneosly in two columns

I need a way to find duplicates in google sheets as shown below

enter image description here

it should be repeating and on both columns on a same row. Thanks in advance

Solution

  • use:

    =INDEX(COUNTIF($A$2:$A&$B$2:$B,$A2&$B2)>1)*(A2<>"")

    enter image description here