How you can get an atomatic serial number in a particular column
Closed
newazz
Posts
1
Registration date
Friday December 7, 2012
Status
Member
Last seen
December 7, 2012
-
Dec 7, 2012 at 01:52 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 7, 2012 at 06:56 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 7, 2012 at 06:56 PM
Related:
- How you can get an atomatic serial number in a particular column
- Nic serial number - Guide
- Whatsup gold free download full version with serial - Download - Networks
- Display two columns in data validation list but return only one - Guide
- How to delete column in word - Guide
- Automatic serial number in excel formula - Guide
2 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Dec 7, 2012 at 04:33 AM
Dec 7, 2012 at 04:33 AM
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.
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.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 7, 2012 at 06:56 PM
Dec 7, 2012 at 06:56 PM
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.
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.
