Dear all,
I am coming across another lengthy task which I would like to have some help with. Here's the deal.
I have a series of set of data to classified (For simplicity and more understanding, I have chosen a set of different shirt sizes).
Based on the unique combination of the first 3 columns (eg. Brand, Style and Order No.), I would need to have the subtotal for all the different sizes (Column 4). Note that there is no header in my data.
I also have 5 different sets of "Sizes". If there is any size with a specific set, then the whole set should be included. If there is no item in a Set of "sizes", then the whole set should be disregarded.
The format in which the output should be is the most critical - it must be exactly as what I have attached in the Sheet 2.
I have also added extra notes on the excel attached. Note: It is important that it is runnable on excel 2003.
I remain at your disposal if you still need further information.
Thanks for giving a go at it.
Bookmarks