Identifying Unique Values from the Duplicates
I found a SS question asked that was basically what i wanted - https://community.smartsheet.com/discussion/46001/duplicates-can-i-count-the-original-but-ignore-2nd-3rd-etc, but I cannot get those formulas to work :(. I then found another website with a slightly different formula - as seen below - that did not work either :(
My goal is to identify the unique values of a column, so I can then hide the others with a filter.
For example: Find a way where the first instant a value appears it produces a "0" let's say, and every other instant it appears, it has a "1" or any other number, that way I can filter for "0's"
When I try adding the "$1" and the "1" to the formula as below, I get a syntax error
=IF(COUNTIF([Physical Mail Assist]$1:[Physical Mail Assist]1, [Physical Mail Assist]@row) <> 1, 0, 1)
This is the formula close to what is on the linked thread - also received a syntax error:
=IF(COUNTIF([Physical Mail Assist]$1:[Physical Mail Assist]1, [Physical Mail Assist]@row) = 1, 1, 0)
(when I drop the "[" & "]" symbols - I also get a syntax error.
Not sure what im doing wrong :( Any help is appreciated!
Help Article Resources
Check out the Formula Handbook template!