How do I do numbering of rows in Excel when there are blank rows?

I want sequential numbering, however, the content contains blank rows. Plus
every time I add a row e.g. in the middle, then I have to re-number the rest
of the list. Is there a quicker way to do this?

In B1: =IF(A1<>"",1,"")
B2: =IF(A2<>"",MAX($B$1:OFFSET(B2,-1,0))+1,"")

and copy B2 down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"V" <[email protected]> wrote in message
news:[email protected]...
> I want sequential numbering, however, the content contains blank rows.
Plus
> every time I add a row e.g. in the middle, then I have to re-number the
rest
> of the list. Is there a quicker way to do this?