Average of n samllest or n biggest numbers from a list

Feb22
2006 Leave a Comment Written by admin

To calculate the average of n biggest numbers from a list enter this formula with Ctrl + Shift + Enter:

=AVERAGE(IF(RANK(yourrange,yourrange)<=n,yourrange,”"))

To calculate the average of n smallest numbers from a list enter this formula with Ctrl + Shift + Enter:

=AVERAGE(IF(RANK(yourrange,yourrange)>COUNT(yourrange)-n,yourrange,”"))

For an example:

Related posts:

  1. Random Numbers
  2. How to loop through a list of data on a worksheet by using macros in Excel
  3. PMT Worksheet Function
  4. List of resources that are available to help you learn Visual Basic for Applications programming
  5. MOD Function and Mod Operator Return Different Values
Posted in Uncategorized
«
»

No Comments Yet

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">