Case sensitive COUNTIF
I'm trying to mark duplicates in a particular column per the discussion here: https://community.smartsheet.com/discussion/comment/319478#Comment_319478
My issue is, the column I'm checking has a mix of uppercase and lowercase letters that define unique IDs, and COUNTIF unfortunately, is case insensitive, so it is marking cells that are not duplicates as duplicates. Is there any way to do a case sensitive check?
- I've already submitted a feature request, referencing the EXACT function that is available in excel which does exact, case sensitive matching.
- I've tried using FIND (which IS case sensitive) and JOIN as such:
=FIND([Main Column]@row, JOIN([Main Column]:[Main Column]), FIND([Main Column]@row, JOIN([Main Column]:[Main Column])) + 1)but that doesn't work due to the 4000 character limit in SmartSheet.