 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Help on averaging a list
Hi experts, This is for calculation of bowling averages. There is a variable length list of numbers in a row (score history of a bowler, new scores appended to the end). What are the functions to find: 1. the average of the last 21 numbers 2. Filter the scores that were above 150, then calculate the average of the last 21 of the filtered list Million thanks!! lento@netfront.net --- Posted via news://freenews.netfront.net Complaints to news@netfront.net If your scores are in column A then: =AVERAGE(OFFSET(A1,MATCH(2,1/(A1:A65535<>0))-1,,-21)) This is an array formula and must be entered with a CNTRL-SHFT-ENTER The same type of formula can be used on a filtered list.  SignatureGary's Student gsnu200701 > Hi experts, > [quoted text clipped - 14 lines] > > --- > Posted via news://freenews.netfront.net > Complaints to news@netfront.net
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.