microsoft excel training company borough high street london - sequential numbering

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

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

resolvedResolved · Low Priority · Version 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:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips


Server loaded in 0.07 secs.