Forum Discussion
Leading "0"s Zeros in numbering items
We have thousands of items that need to be assigned locations that are in a sequence from 01 to 19. E.g., we have location A-01 through location A-19 and then need to increment to B-01 through B19 a...
That's either with number format 00:
=COUNTIFS(A$2:A2,A2)
Or with number format General:
=TEXT(COUNTIFS(A$2:A2,A2),"00")