Sequential Numbering Skipping Blank Rows

[bjnockle]

Looking for non-array sequential numbering skipping blank rows. The non-array formula should look into column A and Column B and add numbers skipping blank cells. Desired outcome is in column C. See attached sample file.

Thanks

[Pete_UK]

Put this formula in C2:

=IF(A2&B2="","",MAX(C$1:C1)+1)

then copy down as required.

Hope this helps.

Pete

[bjnockle]

Pete_UK: Thanks for the proposed solution. I would like to use this formula =IF($A2&$B2="","",TEXT(IFERROR(LOOKUP(9.99999999999999E+307,$C$1:C1+0),0)+1,"0000")). However, it is displaying leading zeros before the actual numbers.

Please assist in adjusting the formula not to show leading zeros. See attached file showing the leading zeros the above formula is displaying.

Thanks

[TMS]

Can't help wondering why. But …

Please Login or Register  to view this content.

One, it depends on the values calculated in column C. And two, it produces a Text value. Why?

[Pete_UK]

... One, it depends on the values calculated in column C. And two, it produces a Text value ...

And three, it is longer to type !!

Pete

[TMS]

And three, it is longer to type !!

Way longer

[TMS]

My mistake. It doesn't have to be dependent on column C, I was just confused by the example with the formula in column D.

So, have it your way, but you probably need this for a numeric output:

Please Login or Register  to view this content.

[Pete_UK]

And it doesn't really need to be the biggest number that Excel can handle - a million would do.

Pete

[bjnockle]

TMS: Excellent work, TMS! Thanks for the rep.

[bjnockle]

Pete_UK: Great solution, Pete_UK! Thanks

[wk9128]

Cell C2 formula , Drag down

Please Login or Register  to view this content.

[TMS]

You're welcome. Thanks for the rep.