Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel training company borough high street london - sequential numbering

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training company borough high street london - Sequential numbering

microsoft excel training company borough high street london - Sequential numbering

ResolvedVersion Standard

Sequential numbering

What would be the formula or otherwise to create the following: Cell a1 contains a number for example 100 Cell b1 contains a date, each time I fill in the date in column b it automatically enter a sequential number in a2,a3,a4 etc i.e 101,102,103 etc

RE: Sequential numbering

type your first number in manually - e.g. 100 in cell A1

then in cell A2 type =if(isblank(B2),"",A1+1)

then drag this formula down as many cells as you would like.

Hope this helps

Paul

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.