Numbering increamental base on value in another colum

Report
-
Posts
2731
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 22, 2021
-
Hello,

I have different numerical value in one column (say A column),
I need to put serial number in another (B) column based in value in A column

Please help

1 reply

Posts
2731
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 22, 2021
459
Hi RPS,

Do you enter your values in column A in order? Like A2, A3, A4.
How does your serial number look like?

Something like this?:
Col A --- Col B
123 --- 123-1
456 --- 456-2
789 --- 789-3

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!