Mar 29 2019 08:10 PM
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 given time).
Thanks much.
Mar 29 2019 11:21 PM
Mar 30 2019 05:11 AM
@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.
Mar 30 2019 06:09 AM
Mar 31 2019 08:21 AM
@Twifoo, I think my original request must have not been clear enough. Attached example shows the two shaded cells, into which I need a formula (which I can copy into other cells of similar nature), where the immediately contiguous cells to the right of the formula, are the ones I need to count.
Hope that's now clearer.
Mar 31 2019 11:32 PM
Apr 01 2019 10:40 AM
@Twifoo, thanks. Would love to understand what the formula is doing, inside to out. I'm not exactly following some of the pieces. Appreciate the extra explanation.