Assuming your list of numbers starting from A1
In B1, try:
=A1&TEXT(COUNTIF($A$1:A1,A1),"00")
Copy down.
Copy and paste special/value to A column, if you want
Assuming your list of numbers starting from A1
In B1, try:
=A1&TEXT(COUNTIF($A$1:A1,A1),"00")
Copy down.
Copy and paste special/value to A column, if you want
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks