LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average over autofilter results QB Excel Worksheet Functions 4 September 30th 09 04:17 PM
autofilter average without zero jane Excel Worksheet Functions 2 September 23rd 08 03:18 AM
Can autofilter sum and average columns of numbers? Thank you Bryan W Excel Worksheet Functions 2 September 18th 06 10:05 PM
Get Average on results of Autofilter [email protected] Excel Programming 3 May 8th 06 11:42 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Excel Worksheet Functions 13 July 31st 05 03:59 PM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"