Formula that can be applied as a Column Formula that marks unique values/entries out in a list
Hi All - I have a sheet that has a list of URLs in one column - lets call that column [HIRE URL]
Some of these URLs are duplicated and I am looking to use a Helper column to mark which ones are unique entries.
I found this formula in another forum post which I adapted to my needs;
=IF(COUNTIFS([HIRE URL]$1:[HIRE URL]@row, [HIRE URL]@row) = 1, 1)
However - this formula cannot be converted to a Column Formula, so it will require ongoing manual effort to keep adjusting it.
Is there a work around available so that I can convert this to a Column Formula? If I add in a row number column and use the MIN function perhaps? Any guidance on this?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!