Excel - Calculation Based On Dynamic CriteriaClosed

Question

Good day,
I have this question as followed:-

I have a table as attached file where I already created a macro to repeat the lines based on the (rounded up) value under column "No. of Carton".  Now, I will need a macro to help to calculate the quantity with the last line of item get the balance quantity. The result should be as seen under column "Carton Qty". 

For example, 1600pcs of oranges with 330pcs per carton means that there will be 5 cartons. 4 cartons will be 330pcs each with the last carton consists the leftover of 280pcs.

Here is my file for reference: http://speedy.sh/92zS7/Book1.xlsx

Appreciate the help and guidance from everyone.

Thank you.

Best regards,
wliang

venkat1926 · Answer

donwload my file from
http://speedy.sh/p7MeX/wilang-131008.xlsx

columns A,B,C are your data.
see formlas i;n other columns in row no. 2 which are copied down. (your calcualtion must be automatic

wliang · Answer

Dear venkat1926,

Thanks for your help. I tried the formula you have provided and it seems fine. However, I would to check with you if it is possible to get the "amt in last column" to be printed at the last row of each category of fruit instead of the first line in the category?

Thanking you in advance for your help.

Best regards,
wliang

Excel - Calculation Based On Dynamic Criteria

2 responses

Similar discussions

Subscribe To Our Newsletter!