Uniforms distribution

[ashwini.sharma241]

Hi I need help in uniform distribution with the help of MS Excel.
I Have merchandise,Size, Rate & Class Chart.
On the other hand i have class with strength...say Grade 1= 15 student . Grade 2=30 student.
Now i need such format in which i just add the ..the number of students in each class & it will update the , size of each merchandise & rate to it.

[Vikas_Gautam]

Need more info so,
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[ashwini.sharma241]

Desired result.xlsxRaw Data.xlsx
Hi Vikas,

Thanks for replying and initiating the help,Attaching Raw data & the desired output for your betting understanding. Please help.

[Vikas_Gautam]

I guess, Sumifs is all what you need after you can define Nursery, LKG, UKG, Grade1 and so and there respective size limits in a table, to be referenced back in Sumifs formula.
Using

Please Login or Register  to view this content.

will get you the Corresponding code of size 34 in Raw sheet.

[ashwini.sharma241]

Hi Vikas,

I am not getting, can i have a call with you to understand?

[Vikas_Gautam]

I guess this is what you were trying to achieve.
Here is the Formula in D4. Copy it and paste it on other cells, References would change automatically.

Please Login or Register  to view this content.

Check the attached file:-
Desired result.xlsx
I guess, you would have a sort of table for Rate as well. So this formula would do for that as well. Enjoy.