financial excel course london - Automatic Number generation

The UK's most regular instructor-led training courses.
Training information: financial excel course london · Advanced.excel · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Automatic Number generation

Sariat has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Sariat [2 posts] (2006 Nov 28 Tue, 10:50) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Automatic Number generation

by - delegate Tristan [6 posts] (2006 Nov 28 Tue, 13:35) Reply

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.

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Microsoft Excel Training: Essential for Today's Employees
· Reasons Why VBA for Excel Training Fails

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips