I am trying to figure out how to find average of top 5 values between two date or in a particular month. I googled but couldn't find a solution.
I am attaching an excel file. I would really appreciate any help.
I am trying to figure out how to find average of top 5 values between two date or in a particular month. I googled but couldn't find a solution.
I am attaching an excel file. I would really appreciate any help.
Last edited by TK2013; 03-17-2024 at 09:47 AM.
Still using Excel 2010?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Are you still using Excel 2010? Please check and, if necessary, update your profile.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes, still using Excel 2010.
Also, what do you want for July... where there are only 3 eligible values for top and bottom 5?
Possiblly this:
=IFERROR(AVERAGE(AGGREGATE(14,6,($B$2:$B$27)/(($A$2:$A$27>=D2)*($A$2:$A$27<=E2)),{1,2,3,4,5})),"Insufficient data")
changing the 14 to 15 for the bottom 5
Thank you, thanks a lot. :thumbs:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks