New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Average top 3 if name matches

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Average top 3 if name matches

Postby msummer18 » Mon Feb 29, 2016 9:19 am

Morning,

What am trying to do if get the average of the top 3 results for each persons name,

Example:
Name Score
John 0.5
Paul 1
Steve 2
John 4
Steve 4
John 5
Steve 5
John 1.75

I can use =average(Large(A1:A8,{1,2,3})) to get the over all average of the top 3, but what I need to do is get the average of the top 3 just for John.

Thanks
  • 0

msummer18
Rookie
 
Posts: 4
Joined: Dec 21, 2015
Reputation: 0
Excel Version: 2013

Re: Average top 3 if name matches

Postby pecoflyer » Mon Feb 29, 2016 11:48 am

Like this ?
  • 1

You do not have the required permissions to view the files attached to this post.
A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: Average top 3 if name matches

Postby msummer18 » Mon Feb 29, 2016 1:46 pm

pecoflyer wrote:Like this ?

Thanks you this works great :D
  • 0

msummer18
Rookie
 
Posts: 4
Joined: Dec 21, 2015
Reputation: 0
Excel Version: 2013

Re: Average top 3 if name matches

Postby pecoflyer » Mon Feb 29, 2016 2:33 pm

You're welcome - Thanks for the rep
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 138 guests