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

Home > Software engineering > I need a way to find duplicates only when occur simultaneosly in two columns

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

Time：04-12

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

CodePudding user response：

use:

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