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)
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)