autofilter average values
 

Hi All,


I have a table with the following headers
Range (A1:L1)
segment 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
I have a list for which I filter this table according to segment and I
need to find the average of each visible column for respective years
and generate it into a new table

I have excel 2002 and Using Subtotal function gives error.

Can someone help me on this?

Thanks
vishnu

autofilter average values
 

You can help yourself by taking a look AGAIN at the help index for SUBTOTAL.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Hi All,


I have a table with the following headers
Range (A1:L1)
segment 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
I have a list for which I filter this table according to segment and I
need to find the average of each visible column for respective years
and generate it into a new table

I have excel 2002 and Using Subtotal function gives error.

Can someone help me on this?

Thanks
vishnu

autofilter average values
 

Thanks Don,

I got it.


On Mar 28, 5:12*pm, "Don Guillett" wrote:
You can help yourself by taking a look AGAIN at the help index for SUBTOTAL.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
om wrote in message

...



Hi All,

I have a table with the following headers
Range (A1:L1)
segment 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
I have a list for which I filter this table according to segment and I
need to find the average of each visible column for respective years
and generate it into a new table

I have excel 2002 and Using Subtotal function gives error.

Can someone help me on this?

Thanks
vishnu- Hide quoted text -

- Show quoted text -