Hi everyone,
I have the following formula that I'm using to add an underscore and number to a column of IDs-some of these ids are only differentiated by having a capital letter on the end or a small letter, which means they are different, even if the letter itself if the same:
Example:
abedA
abeda

=B2&"_"&COUNTIF($B$2:B2,B2)

Is there a way to make countif case sensitive so it knows that the Ids with a capital letters are different than ids with small letters?

Thank you!