Wondering if there is a way to do this without using macros...
I have a table of values listed where columns are dates (earliest on the left) and rows contain values. I am looking for a formula to return the number of values, counted left to right, it would take on a given row it would take to meet another value....awkward explanation;
comma delimited example here, i cannot upload files sorry. Copy paste and text-to-col starting in cell A1
VALUE,How many,Date 1,Date 2,Date 3,Date 4,Date 5
950,4,321,432,17,53,5432
569,2,157,364,100,136,158
11300,3,100,1000,10000,1000,1000
Column B shows where the formula would be. The number represents how many cells (counted from left to right) in range D:G can be summed before the value in column A is reached or exceeded. Oh also it needs to skip blanks (values in columns C and D can be blank with values starting in E)
Thanks in advance!
Bookmarks