Assistance with #Unparseable error.

System

This discussion was created from comments split from: Find and Highlight duplicates in column.

drichart

I have a similar issue where I have a Claim No column that I need to see where my duplicate entries are so I can review & remove them. I'm very new to this as well and I created a Duplicates column on my SS and set it up as a checkbox column. I entered the following formula (similar to yours above Andree) in the first cell of the duplicates column but it is showing #unparseable:

=IF(COUNTIF([CLAIM NO]:[CLAIM NO], [CLAIM NO]@row) > 1; 1)

Not sure what I'm doing wrong here?

Kelly Drake

@drichart flip that semicolon to a comma and it should work for ya!

=IF(COUNTIF([CLAIM NO]:[CLAIM NO], [CLAIM NO]@row) > 1, 1)

drichart

Thanks Kelly, that worked :)