Prev: Copy and Past Values AND Formatting AND Text
Next: sub total value
From: Michele on 6 May 2010 13:47
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

From: Luke M on 6 May 2010 14:00
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.

--
Best Regards,

Luke M
"Michele" <Michele(a)discussions.microsoft.com> wrote in message
news:F9A3B6F9-F3B1-462F-B595-5D6AB173BFDB(a)microsoft.com...
>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
>


 | 
Pages: 1
Prev: Copy and Past Values AND Formatting AND Text
Next: sub total value