How to insert auto serial no. in excel?

I need to put auto serial simply no.in surpass.For example, when I may type a thing in B1 cell phone, serial simply no.1 are going to be automatically demonstrated in A1 mobile, again if i type some thing in B2 mobile, serial simply no.2 are going to be automatically proven in A2 cell and so on.How will i do this kind of in stand out (2003/2007)

In A1 input =IF(B1=””, “”, 1)

Throughout A2 input =IF(B2=””, “”, A1+1) copy this affordable the column.Whenever an entry is typed in in column B the subsequent number so as will be entered in column YOUR.

It isn’t really easy to complete without VBA.There are actually ways to generate numbers employing functions (such as =A1+1 or maybe =ROW() ), but not to help make unchanging numbers which have been *independent* of each one other (i.at the.can possibly be sorted or filtered without consequence).Functions including =RAND() or maybe =NOW() can change their values each and every time you create an admittance, unless people change Excel’s version options.

Together with VBA, you are able to add any routine which checks to get entries within the B column, and inserts many in that matching A-column cell.You can use date/timestamps or maybe random amounts.

A NEW database software (like Microsoft Access or maybe OpenOffice.org Base) typically has a good Autonumber or Autovalue function integrated, and could possibly serve your requirements better over a spreadsheet would.

What I did once appeared to be similar, take a look at “CustomDocumentProperties”.People can
add any “Serial number” house there and the majority users aren’t even conscious of it.
It may be installed and also retrieved throughout code immediately, but you’d probably need
to store some form of counter in your program file.

just do these steps:
A SINGLE:open surpass sheet
3:in that any place in the sheet you only place ONE PARTICULAR, 2 serial numbers
3 OR MORE:then individuals two cells you will need to drag simply by pressing sensitive mouse left button
then u are certain to get serial quantities upto that number ough want.