Hi everyone,
I don't imagine my problem is too difficult to solve, however, I can't find anything about it on google. Basically, I have a column where the entries are strings of text. I want to remove all duplicates in the column in a case-sensitive manner. Unfortunately, the remove duplicates function in excel treats, for example, "LRV" and "LRv" as duplicates when in fact these should be considered unique. Any suggestions would be very much appreciated.
Bookmarks