• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Stock age(Stop when target reached formula)

T

tobias1989

New Member
Hi

Long time user of forum, but first time poster.

I got problem in Excel i simply can't solve.

I have a stock quantity, i want to know how old is, based on purchases.

I want the excel formula(not vba) to stop/be "0" when my stock quantity is reached.

Could you please help a desperate excel fan.

I have attached a example of my issue in Excel
Thank you in advanced, and thank for saving my ass, tons of times before :)
 

Attachments

  • stock.xlsx
    10.3 KB · Views: 11
tobias1989
One sample ...
... but what/how do You really would like to solve?
ex. Do You would like to 'control' right side values?
 

Attachments

  • stock.xlsx
    10.6 KB · Views: 8
vletm said:
tobias1989
One sample ...
... but what/how do You really would like to solve?
ex. Do You would like to 'control' right side values?
Click to expand...

I would like the "left numbers" to lookup the values in the "right numbers" until my current stock number(D6/D7 in example) is reached, and then show "0" after this.
( i have massive stock list to do this with)
 
Sorry din't see your comment, and thanks for replay :)
I the last column(I7) i need it to only be 5(remaining amount).
Yes, but the size is the same, so i should be able to just copy down, when first line i made
 
tobias1989
There were also question like:
ex. Do You would like to 'control' right side values?
You need those 5 but there are more right side!
... ex always 20 'in one set'.

'massive'
Iif there are also many months and
massive stock list then ...
Of course, You can fill the whole sheet with formulas!
 
You must log in or register to reply here.
Back
Top