Nearest Month


S

Sky

Hi,

Is there a way or formula in the excel to get the ans indicate below Column
G)
Column A is the product.
Column B to D is the month and Qty
Column F is the Qty need.
Column G is the column that I wish to get the month and Qty.
I am trying to nearest and early month to get the ans. by doing that i could
know how longis the lead time for the product.

Jan-09 Feb-09 Mar-09 Apr-09 Qty Ans
A 100 100 o 100 200 Apr(100) Mar(0) Feb(100)
A need 3 month to
get 200
B 100 0 50 100 250 Apr(100) Mar(50) Feb(0)
Jan(100)
B need 4 month to
get 250
 
Ad

Advertisements

P

PJFry

Sky,

Try re-wording you question. Saying 'I am trying to nearest and early month
to get the ans.' does not give enough information. What is a 'nearest and
early month'?
 
S

Sky

Hi PJFry

I wish to find a formula in the excel to help me to pull out the latest
month to meet the qty.
For example
 
S

Sky

Hi PJFry

I wish to find a formula in the excel to help me to pull out the latest
month to meet the qty.
For example
 
S

Sky

Hi PJFry

I wish to find a formula in the excel to help me to pull out the latest
month to meet the qty.
For example
Jan-09(100) Feb-09(100) Mar-09(100) Apr-09(0) May-09(100)

I need 200 and the ans is Mar-09(100) Apr-09(0) May-09(100)
Total I need 3 month to get 200
 
Ad

Advertisements

S

Sky

Hi PJFry

I wish to find a formula in the excel to help me to pull out the latest
month to meet the qty.
For example
Jan-09(100) Feb-09(100) Mar-09(100) Apr-09(0) May-09(100)

I need 200 and the ans is Mar-09(100) Apr-09(0) May-09(100)
Total I need 3 month to get 200
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top