| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average over autofilter results | Excel Worksheet Functions | |||
| autofilter average without zero | Excel Worksheet Functions | |||
| Can autofilter sum and average columns of numbers? Thank you | Excel Worksheet Functions | |||
| Get Average on results of Autofilter | Excel Programming | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
Linear Mode
