Excel subtotals

M

Michele

I have a list that is approx 2000 rows by 8 columns (A:H) which needs to be
subtotaled in Column H on each change in column G. Once the list is
subtotalled it needs to be filtered to only show the rows which do NOT result
in a subtotal of 0. How can I do this?

Thank you,
Michele
 
L

Luke M

You could setup the subtotals using the Data - Subtotal dialogue. Then, add
a helepr column to your data (I) witht his formula:
=VLOOKUP(G2&" Total",G:H,2,)<>0

Then filter on this column for TRUE.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Macro 0
Quick/efficient way to VBA subtotal 2
Using Subtotals tool to average multiple rows of non-continuous data based on ID # 0
Using sumif with subtotal 8
Macro Pause to Select range then Subtotal 0
Help! Subtotal using formulas or VBA 5
Getting Text data using the Data - Subtotal feature 1

Top