I have an Excel Spreadsheet (Excel 2003) and I need to filter out some records based on 2 columns
For example Column B I want to filter out all records that are of a specific value for example "A539"
Then on top of that I also want to filter out on those records that are in column L that are blank.
Once I have filtered out the records I want to Group on Column G, Group on Column H, then give me the sum of values in Column I
for example the attached excel spread sheet is you can assume I have already run a filter to get me to the stage of showing those that are A539 and are blank in column L.
I am trying to get it so that the results will be
Black L 22
Black M 1
Beige M 2
Beige L 7