financial excel course london - Automatic number generation

Resolved · Low Priority · Version Standard

Tue 28 Nov 2006, 10:50 Delegate Sariat said...

Sariat has attended:
Excel Intermediate course
Excel Advanced course

Automatic number generation

Is there a way of generating automatic numbers / identifiers in Excel for each record created in a speadsheet? I would also like the number / identifier to have a specific format (i.e. 3 letters/year/3 digit number). Thanks.

Tue 28 Nov 2006, 13:35 Delegate Tristan said...

RE: Automatic Number generation

Sariat - I have a spreadsheet that does this, but I must confess I didn't create it! This formula puts automatic numbers starting from 1, into column A, when you enter data into column B.

=IF($B2<>"",IF(ISNUMBER($A1),VALUE($A1)+1,1),"")

Do note though that if you leave a row blank in Column B it will then start counting from 1 again.

I honestly doubt that your format will be possible, but you could have a separate colum already set up containingg your 3 letters/year/, and then use a further column to merge that and the number together e.g. =A2&C2. That just merges the data from those two cells into one.

Hope that's useful.

Tristan

PS. You can probably also learn this through Microsoft Excel training which these guys offer on public schedule.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips