Finding a duplicate in a column
I have a "name" column and a "HRC code" column and want to find duplicates in each column.
The following formula works just fine for the name column but it wont work for the HRC Code column I believe bc the name of the column has a space. Is there a workaround or do I have to rename the column? (I prefer not)
IF(COUNTIF(Name:Name, Name@row) > 1, "Yes", "No"))
Help Article Resources
Check out the Formula Handbook template!