[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 100
  • Last Modified:

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
  • 2
1 Solution
Glenn RayExcel VBA DeveloperCommented:
This sure sounds like a job for Pivot Tables!

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.
Example set up
If you could provide a larger set of sample data - unfiltered - I could send you an example file with a Pivot Table.

Glenn RayExcel VBA DeveloperCommented:

Did you have any additional questions or issues with the solution I provided?  If so, let me know.

Otherwise, please properly close this question by clicking the "Accept this solution" link above my previous post.  That will ensure that the answer is available to others searching for a similar solution and that points are awarded.

With Thanks,

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now