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!
Hi,
Perhaps:
=B2&"_"&SUMPRODUCT(--EXACT($B$2:B2,B2))
Regards
Try this...
=B2&"_"&SUMPRODUCT(--EXACT(B$2:B2,B2))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi,
-----
edit : same answer, sorry I did not mean to overlap!
Stefano
---------
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Use the EXACT Function to check exact strings.
=B2&"_"&COUNTIF($B$2:B2,EXACT(B2,UPPER(B2)))
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
Thanks Canapone- that worked! What does the double dash represent?
See this:Originally Posted by jessbr
http://xldynamic.com/source/xld.SUMPRODUCT.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks