I've been trying to figure out a way to identify duplicates in my sheet in some way. I'm not picky if that's a checkbox or a flag - it really doesn't matter. I've researched a few formulas through the community and cannot seem to get them to take. I get an #UNPARSEABLE each time.
How do I call out the top 2 ID's as duplicates? There's definitely a step I've missed in following the formulas that are out in the community. Any advice?
Help Article Resources
Check out the Formula Handbook template!