Average with large and small function

rexysri

New Member
Joined
Mar 2, 2016
Messages
27
Office Version
  1. 365
  2. 2021
  3. 2019
  4. 2016
  5. 2013
Platform
  1. Windows
  2. Mobile
Hello lovely humans,

I'm trying to average the values of column-B, C, & D based on top-3 values of Column-E.
Dean wise averages i want . Here i am attaching a pic plz help me

Capture.JPG
 
You understand what you want but I'm afraid that I don't. That is why I asked for the expected results & an explanation of how they would be obtained manually.
 
Upvote 0

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).


column B contains Different states,
so here we need state wide averages will be posted in column O to P
 
Upvote 0
sample data.xlsx
NOPQRSTUV
2NORTH
3RANK RANGEMMMRPMPRCMCRTMTR
4<=594.0092.0098.00284.0094.00
5<=1088.6786.0095.33270.0088.67
6<=1587.0084.5094.50266.0087.00
7<=2086.6783.5694.22264.4486.67
8<=3082.8681.4393.71258.0082.86
9<=4083.5680.2292.44256.2283.56
10<=5082.6180.5292.70255.8382.61
Sheet1
 
Upvote 0
thank you for your patience peter

i want the averages of Math marks, Phy marks, Che marks, Top 3,5,10 (largest to smallest) values of column K, as well as averages of maths rank , phy rank, che rank based on (smallest to largest) values of column L.
 
Upvote 0

Forum statistics

Threads
1,226,532
Messages
6,191,607
Members
453,667
Latest member
JoeH7745

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top