Use the EXACT Function to check exact strings.
=B2&"_"&COUNTIF($B$2:B2,EXACT(B2,UPPER(B2)))
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks