I have a need to take some data in it's raw form and aplly a macro to it so it will group by DIvision, Class, style and colour and then rank them by highest to lowest by total's by style.
I have attached an excel sheet with 2 tabs. The Raw Data and the Desired output.
The key here is that the data needs to be alphabetical for the first 2 columns on the left - DIVISION and CLASS. Then the Styles will be in the order of Total units by Style which i need to be calculated and grouped as shown. Then ranked at the Class level. (Not Division Level)
THis would be a great help if i could get something to run like this so i can apply it to a much larger amount of Data.