• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Increment a Row

C

CMLET

Member
a a
x 3
x 2
x 1
a a
x 3
x 2
x 1
a a
x 1
a a
x 5
x 4
x 3
x 2
x 1
a a

Hi Mr. Excel(lent). =IF(A1<>"","",MAX($A$1:A65356),"") I'm stuck! Example: in the 1st column, (x) indicate blank cells. Need to number the blank rows in down the column between a's. Example above, right column.
 
You must log in or register to reply here.
Back
Top