GenieMaster
asked on
Excel Group Columns
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
Expert-Sample.xls
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
Expert-Sample.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could create a Pivot Table from your master data, then set the Report Filters to "A539" for your column B field and "(blank)" for the column L field.
You'd then make the fields for column G and H the Row Labels and the values in column I as the Values.
If you could provide a larger set of sample data - unfiltered - I could send you an example file with a Pivot Table.
-Glenn