I have a value that needs to be distributed among a set of other smaller ones?
Say, I have a list of students with their grades, and I need to distribute a scholarship fund among them according to their grades.
How do I do that?
MS Excel question?
Details:
Answers (1)
hi,
you should use filter option, it can help you according to needing work.
Apply filter option on the selected sheet.
1. select all cells in the categorized row.
2. press ctrl+shift+L, a small filter icon will in the selected cells.
3. Click on icon and use filter function.
I hope it does fulfill your need.
thanks.
Hi!
Thanks for the info. the thing is that the value range is 0 to 300 and applying filters won't help. I thought of a math function, that could distribute the amount according to item value ratios.