Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Calculate average, delete highest and lowest score

  1. #1
    Join Date
    19th September 2004
    Posts
    2

    Calculate average, delete highest and lowest score

    Hi,

    My question is similar to the choosing best of 10 questions. I need to average ratings for a group of seven after deleting the highest and lowest score.

    Thank you for your help.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th July 2004
    Location
    Tokyo, Japan
    Posts
    8,481
    Hi,

    try

    =(SUM(yourRange)-MAX(yourRange)-MIN(yourRange))/(COUNT(yourRange)-2)

    replace yourRange with actual range.

    hope it helps

    jindon

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    19th September 2004
    Posts
    2
    Thank you. I tried it with my data and it does exactly what it was supposed to.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Highest To Lowest Values By Condition
    By squirtle in forum EXCEL HELP
    Replies: 3
    Last Post: February 7th, 2008, 03:04
  2. Record Highest/Lowest From DDE
    By imjscn in forum EXCEL HELP
    Replies: 6
    Last Post: August 7th, 2007, 19:14
  3. Ranking - highest to lowest
    By Damo01 in forum EXCEL HELP
    Replies: 3
    Last Post: June 20th, 2006, 15:13
  4. Sorting Data From Highest To Lowest
    By kevfeng in forum EXCEL HELP
    Replies: 4
    Last Post: June 15th, 2005, 23:10

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno