Create a Duplicate Flag

04/30/20
Accepted

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)

Popular Tags:

Best Answer

  • Maria WattersMaria Watters ✭✭✭✭✭
    edited 04/30/20 Accepted Answer

    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)

Answers

  • Maria WattersMaria Watters ✭✭✭✭✭
    edited 04/30/20 Accepted Answer

    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)

Sign In or Register to comment.