This post is to show the formulas used in this video.

To find duplicate rows:

`=IF(COUNTIFS(A2:A$2,A2,B2:B$2,B2,C2:C$2,C2)>1,"Duplicate","")`

To find duplicate cells:

`=VLOOKUP(A2,'West Storage-1'::A$2:A$11,1,FALSE)`

Skip to content
# Apple Numbers – Remove Duplicates

This post is to show the formulas used in this video.

To find duplicate rows:

`=IF(COUNTIFS(A2:A$2,A2,B2:B$2,B2,C2:C$2,C2)>1,"Duplicate","")`

To find duplicate cells:

`=VLOOKUP(A2,'West Storage-1'::A$2:A$11,1,FALSE)`