How you can get an atomatic serial number in a particular column

[Closed]
Report
Posts
1
Registration date
Friday December 7, 2012
Status
Member
Last seen
December 7, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
Suppose A1 is serial, B1 persons name, C1 amount due, D1 amount paid, E1 invoice number, F1 is invoice date and so on, that is A2, B2, C2.......
Now if you entered an amount in D1 cell, how you can obtain an atogeneration number (say 101) in E1 cell (invoice numver). Again you entered an amount in D5 cell, how you can obtain next serial number (102) in E5 cell (invoice numver, and so on.
Thanks

2 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
Hi newazz,

Use this formula in F2 and then drag using Microsoft Excel's fill handle till the end of data:

=TEXT(ROW(A1),"100")

This formula will populate the respective cells with serial number starting from 101. You can replace "100" with your desired sequence.

Do reply with results.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Since first invoice is in D1 and 2nd in D5, and you want numbers to be 101 and 102 respectively, you would need a macro to do that.

From you question it seems to me that you want number to be generated when a cell in D column is populated. Will there be any thing else in D column (lets say in D2) for which you do not want auto number to be present in E2.