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

user_7848676 0
Viewed 22

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

conditional-formatting google-sheets conditional-statements if-statement duplicates
1 Answers

use:

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

enter image description here

user_56326290
Related