Count Columns Until Value Reached

welcome to the forum, phelbin. try this array formula in E3:
=MATCH(TRUE,SUBTOTAL(9,OFFSET(G3,,,,COLUMN(G3:AX3)-COLUMN(G3)+1))>=C3,0)-COUNTBLANK(G3:AX3)

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Hi and welcome to the forum!

You don't include your desired results, and it's not clear if you want the number of months to be counted from the first non-blank cell in the range, or from Mar-05 regardless. However, assuming the former, this array formula** in E3:

=MATCH(TRUE,MMULT((--(TRANSPOSE(COLUMN(INDEX(G3:AX3,MATCH(TRUE,G3:AX3<>"",0)):AX3))>=COLUMN(INDEX(G3:AX3,MATCH(TRUE,G3:AX3<>"",0)):AX3))),TRANSPOSE((INDEX(G3:AX3,MATCH(TRUE,G3:AX3<>"",0)):AX3)))>=C3,0)

Copy down as required.

Regards


**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

I've run into a problem with the formula. Please see "Product 5" on attached spreadsheet.

In the case that we discontinue a product, there will be blank cells on the end of the string of sales data. Can the formula account for that? At this point, it seems to ignore the blank cells up front, but it subtracts one for each blank cell on the end from the output.

The current formula being used is: =MATCH(TRUE,SUBTOTAL(9,OFFSET(G3,,,,COLUMN(G3:AX3)-COLUMN(G3)+1))>=C3,0)-COUNTBLANK(G3:AX3)

maybe in E9:
=MATCH(TRUE,SUBTOTAL(9,OFFSET(G9,,,,COLUMN(G9:AX9)-COLUMN(G9)+1))>=C9,0)-MIN(IF(G9:AX9<>"",COLUMN(G9:AX9)-COLUMN(G9)+1))+1

array still. do remember to mark the thread as Solved. thanks
=)