PC Review


Reply
Thread Tools Rate Thread

how can get average of 3 max values out of 7 values in a row

 
 
=?Utf-8?B?TW9iaW4=?=
Guest
Posts: n/a
 
      28th Oct 2007
how can get average of 3 max values out of 7 values in a row
 
Reply With Quote
 
 
 
 
=?Utf-8?B?ZXhjZWxlbnQ=?=
Guest
Posts: n/a
 
      28th Oct 2007
=AVERAGE(LARGE(A2:A8,{1,2,3}))


"Mobin" skrev:

> how can get average of 3 max values out of 7 values in a row

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to go to last row with values and average previous 30 values soccerdav2003 Microsoft Excel Programming 4 9th Jun 2008 09:45 PM
A formula to AVERAGE IF but only average a set number of values DonFlak@gmail.com Microsoft Excel Worksheet Functions 2 31st Jan 2008 08:28 PM
average values in non-contiguous cells, ignoring 0 values =?Utf-8?B?Uldvcm1kYWhs?= Microsoft Excel Worksheet Functions 3 30th Oct 2006 01:06 AM
Exclude null values in average of a column of values? =?Utf-8?B?TkNfU3Vl?= Microsoft Access Reports 5 6th Jan 2006 03:00 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Microsoft Excel Worksheet Functions 13 31st Jul 2005 03:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:22 PM.