Create a Duplicate Flag
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)
Best 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
-
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)
-
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?
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!