Forum Discussion
counting contiguous cells
I need to count the contiguous cells on a row, to the right of a cell. Any way to do that (even though there may be other cells beyond it, and I won't have a firm number on how many that is at any g...
You may try this formula in B2:
=COUNTA(C2:INDEX(2:2,COUNTA(2:2)))
=COUNTA(C2:INDEX(2:2,COUNTA(2:2)))
Twifoo, thanks (for your several responses), what if I don't know that it's row 2 in which I need this? This will go into varying rows, and those rows may shift over time with insertion above it, so I need that part of the formula to self-adjust with it. How would I alter this to accommodate for that?
Thanks again.