I am not sure how to accomplish sorting the variables in the array. They need to be sorted from highest value to lowest. Then the allowance is calculated (100% of highest, the rest at 50%).
The attached spreadsheet outlines the steps and gives an examplePlease Login or Register to view this content.
Bookmarks