How about adding a helper column to calculate the subtotal (but on every
row, not at the end), and then filter out those that are 0.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"michael.beckinsale" wrote in message
oups.com...
Hi All,

I have a list which is approx 35000 rows by 9 columns (A:I) which
needs to be subtotalled in Column G on each change in column A. There
will be approx 2800 subtotals. Once the list is subtotalled it needs
to be filtered to only show the rows & which do NOT result in a
subtotal of 0.

I have tried data/subtotals but you cannot filter the result.

I attemped to put a formula in column J to total on each change in
column A but the number of elements in column A is variable, so
finding the number of rows to total is difficult if not impossible.

Seems to me that l am left with VBA but l have no idea what the code
should look like!

Anybody got any ideas / sample code. This is really starting to
frustrate me.

TIA

Regards

MB