Increment Cell by one: 2 conditions

[Irish Guy]

I am looking to increment Column A by one, if the corresponding cell in Column B has text.

It gets tricky as shown in the picture attached / linked at row 9 and 10. B9 and B10 have no text, so A9 and A10 are not incremented.

The next column with text is B11, so that value in A11 is 9.

Is there a formula that could do this automatically?

Thanks guys.
http://farm6.staticflickr.com/5442/9...f53f5f31_o.png

excel condition.PNG


Attachment 250611

[Ace_XL]

In A2

=IF(B2="","",MAX($A$1:A1)+1)

copy down

[Irish Guy]

In A2

=IF(B2="","",MAX($A$1:A1)+1)

copy down

Hey Ace_XL, thanks for your suggestion.

I have tried this a few times, but it does not appear to work.

I must note that the blank cells also contain formulas (but I also tried deleting the formulas - this did not affect the suggestion solution)

[Irish Guy]

SOLVED: put a 1 in A1 and then put the formula in A2 and copy it down

=IF(B2="","",1+LOOKUP(999999,A$1:A1))