Use the COUNTIF formula to find duplicates.

PHOTO EMBED

Mon Aug 12 2024 12:13:04 GMT+0000 (Coordinated Universal Time)

Saved by @baamn #sheets

=COUNTIF (A:A, A1)>1
content_copyCOPY