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
GenieMasterAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
0
Glenn RayExcel VBA DeveloperCommented:
Hi,

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,
-Glenn
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.