How to create serial numbers
Solved/Closed
Related:
- How to create serial numbers
- Create skype account with gmail - Guide
- Create snapchat account - Guide
- How to create viber group - Guide
- Create a yahoo email account for free - Guide
- Create instagram account - Guide
6 responses
Friends,You Can Use ROW() function for generating serial numbers,
for example,
in A1 cell write
=ROW() and press Enter,that will give 1 as answer.
Now click on A1(i.e. Select it)-> Press Ctrl+Shift+Down(to select the below fields which will get its serial now..) -> After selecting the column Goto--EDIT->FILL->DOWN
This will fill all the cells with the respective ROW number...
U can also use arithmetics with ROW(),if any such requirements are there.
This method is for generating manually.
For automatic ID generation,you can refer to MACROs in excel.
Do put Thanks,if this was helpful because I tried for the whole day to find this....See you..
for example,
in A1 cell write
=ROW() and press Enter,that will give 1 as answer.
Now click on A1(i.e. Select it)-> Press Ctrl+Shift+Down(to select the below fields which will get its serial now..) -> After selecting the column Goto--EDIT->FILL->DOWN
This will fill all the cells with the respective ROW number...
U can also use arithmetics with ROW(),if any such requirements are there.
This method is for generating manually.
For automatic ID generation,you can refer to MACROs in excel.
Do put Thanks,if this was helpful because I tried for the whole day to find this....See you..
Hi,
I have an excel worksheet contains various rows and I want to make a serial number automatically how to get it through a formula.
few rows contains values and others dont.
Regards,
ARUN
I have an excel worksheet contains various rows and I want to make a serial number automatically how to get it through a formula.
few rows contains values and others dont.
Regards,
ARUN
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 15, 2010 at 07:25 AM
Feb 15, 2010 at 07:25 AM
Assumptions
1. You want series to appear in Column A
2. If a row has a data, then column B of that row would have data
3. Row 1 is a header
Write in Cell A2
=IF($B2="","",COUNTA($B$2:$B2))
Drag this formula down
1. You want series to appear in Column A
2. If a row has a data, then column B of that row would have data
3. Row 1 is a header
Write in Cell A2
=IF($B2="","",COUNTA($B$2:$B2))
Drag this formula down
YeohSeow
Posts
17
Registration date
Sunday May 2, 2010
Status
Member
Last seen
May 25, 2010
May 5, 2010 at 10:02 AM
May 5, 2010 at 10:02 AM
Dear rizvisa1,
how to edit this formula if I want the serial no start with JNP folow by no.
Thanks
how to edit this formula if I want the serial no start with JNP folow by no.
Thanks
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 5, 2010 at 10:04 AM
May 5, 2010 at 10:04 AM
To add JNP and have the series
=IF($B2="","", "JNP " & COUNTA($B$2:$B2))
=IF($B2="","", "JNP " & COUNTA($B$2:$B2))
YeohSeow
Posts
17
Registration date
Sunday May 2, 2010
Status
Member
Last seen
May 25, 2010
May 5, 2010 at 10:08 AM
May 5, 2010 at 10:08 AM
Thank alot
Friends,You Can Use ROW() function for generating serial numbers,
for example,
in A1 cell write
=ROW() and press Enter,that will give 1 as answer.
Now click on A1(i.e. Select it)-> Press Ctrl+Shift+Down(to select the below fields which will get its serial now..) -> After selecting the column Goto--EDIT->FILL->DOWN
This will fill all the cells with the respective ROW number...
U can also use arithmetics with ROW(),if any such requirements are there.
This method is for generating manually.
For automatic ID generation,you can refer to MACROs in excel.
Do put Thanks,if this was helpful because I tried for the whole day to find this....See you..
for example,
in A1 cell write
=ROW() and press Enter,that will give 1 as answer.
Now click on A1(i.e. Select it)-> Press Ctrl+Shift+Down(to select the below fields which will get its serial now..) -> After selecting the column Goto--EDIT->FILL->DOWN
This will fill all the cells with the respective ROW number...
U can also use arithmetics with ROW(),if any such requirements are there.
This method is for generating manually.
For automatic ID generation,you can refer to MACROs in excel.
Do put Thanks,if this was helpful because I tried for the whole day to find this....See you..
Didn't find the answer you are looking for?
Ask a question
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 14, 2010 at 08:20 AM
Feb 14, 2010 at 08:20 AM
Not sure what you are looking for. The rows number have series. If you want to additionally show numbers as serial, you can write 1 at the top of the row and drag it down to have a Serial Number.
assalam o alykum
thanks lot
thanks lot
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 12, 2010 at 04:19 PM
May 12, 2010 at 04:19 PM
WS and you are very welcome
Apr 14, 2012 at 06:10 AM
Apr 27, 2012 at 01:47 AM
May 8, 2012 at 08:23 PM
Nov 24, 2017 at 06:33 AM