Hi Gary,

Could you kindly provide to provide me the formula.

Thanks a lot
Kang Yong

"Gary Brown" wrote:

I think only a user-defined-function (UDF) will do what you want.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Sky" wrote:

Hi,

Is there a way or formula in the excel that could help to add the nearest
month to get the figure for Column F.
The month added up can be greater than or equal to Column F.
Column A to E is the month.
Column F is the Qty.
Column G is the column that I wish to get the month and Qty.

Jan-09 Feb-09 Mar-09 Apr-09 May-09 Qty Ans
100 100 100 100 300 May(100) Apr(0)
Mar(100) Feb(100)
100 100 100 100 250 May(100) Apr(100)
Feb(100)
100 100 100 100 300 May(0) Apr(100)
Mar(100) Feb(100)
100 100 100 100 50 May(0) Apr(100)
100 100 100 50 May(0) Apr(0)
Mar(100)