Numbering increamental base on value in another colum

Closed
RPS - Apr 9, 2021 at 04:18 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 20, 2021 at 12:11 PM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 20, 2021 at 12:11 PM
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
0