Create a Duplicate Flag

Maria Watters · 04/30/20

Hello,

I am trying to create a flag that turns red when a duplicate name is entered. Here is the formula I have so far, but it keeps telling me it is "#Unparseable"

=IF(COUNTIF([Client/Resident Name]:[Client/Resident Name]@cell) > 1, 1)

Maria Watters · 04/30/20

Never Mind! I figured out what I was missing:

This worked for me: =IF(COUNTIF([Client/Resident Name]:[Client/Resident Name], [Client/Resident Name]@row) > 1, 1, 0)

Maria Watters · 04/30/20

Never Mind! I figured out what I was missing:

This worked for me: =IF(COUNTIF([Client/Resident Name]:[Client/Resident Name], [Client/Resident Name]@row) > 1, 1, 0)

Ward Mizell · 08/29/23

I am trying to track duplicate serial numbers in a Column. If a duplicate serial number in a Column occurs, I would like a flag to pop up in a column next to the SN column. This formula only seems to affect the first row. How do I make it affect all rows in a column?

Genevieve P. · 08/30/23

Hi @Ward Mizell

Can you post the formula you're using and a screen capture of the sheet (but block out sensitive data)?

If you meant that you pasted the formula in the first row cell and want to apply it to the entire column, right-click on the cell and change it to be a Column Formula

See: Use column formulas to apply calculations to all rows in a sheet

Cheers,

Genevieve

Create a Duplicate Flag

Best Answer

Answers

Help Article Resources

Categories