Prev: Conditional formatting with expired dates after current
Next: Unable to set the FormulaArrary property of the range class
From: Brandon on 13 Apr 2010 02:04
I want to return the first date in which the sum of the previous columns
first exceeds inventory on hand (total). Should return 4/5 on this example.

Total Due Date 3/24 3/30 4/5 4/7 4/7
68 #N/A 10 50 20 30 30

I am using nested if's, but need to expand to more than 7 columns, using
excel 2003.

Thanks
From: Stefi on 13 Apr 2010 05:48
I couldn't find a single formula, but if you set up a helper row with this
formula in C3 and filled to the right:
=SUM($C2:C2)
then
=INDIRECT(ADDRESS(1,MATCH(A2,C3:G3,1)+1+2,4,1))
gives the required result.

--
Regards!
Stefi



„Brandon” ezt írta:

> I want to return the first date in which the sum of the previous columns
> first exceeds inventory on hand (total). Should return 4/5 on this example.
>
> Total Due Date 3/24 3/30 4/5 4/7 4/7
> 68 #N/A 10 50 20 30 30
>
> I am using nested if's, but need to expand to more than 7 columns, using
> excel 2003.
>
> Thanks
 | 
Pages: 1
Prev: Conditional formatting with expired dates after current
Next: Unable to set the FormulaArrary property of the range class