Help with Autofill

[boorman]

Hello
I have a worksheet that I wish to use autofill (of a vba equivalent).
Effectivly what I want to do is restart the autofill by each blank line

What I am trying to achive is count of boxes in a sheet

Box name Box qt
1
1
1
1
BLANK LIN
2
2
2
2
2
BLANK LIN
3
3
3

Is there an easy way to do this

Thanks in advance

 

[Don Guillett]

Hello,
 I have a worksheet that I wish to use autofill (of a vba equivalent).
 Effectivly what I want to do is restart the autofill by each blank line.

 What I am trying to achive is count of boxes in a sheet.

 Box name    Box qty
 1                     1
 1                     2
 1                     3
 1                     4
 BLANK LINE
 2                     1
 2                     2
 2                     3
 2                     4
 2                     5
 BLANK LINE
 3                     1
 3                     2
 3                     3

 Is there an easy way to do this?

 Thanks in advance

There may be an easier way
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[Jim Cone]

Titles in row 1, Names in column A, Formula begins in B2 ...

=IF(ISBLANK(A2),"",IF(OR(ISBLANK(A1),ISTEXT(B1)),1,B1+1))
'--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(XL Companion add-in: compares, matches, counts, lists, finds, deletes...)




"boorman" <[email protected]>
wrote in message
news:[email protected]...

 

[Pete]

Very slick.
Pete

 

[Jim Cone]

Thanks.
'--
Jim Cone


"Pete" <[email protected]>
wrote in message
Very slick.
Pete