AnalystInNeedOfHelp
New Member
- Joined
- Apr 20, 2013
- Messages
- 2
Can someone please help me with a formula. I have a list of % figures in a column. I need a formula that will calculate the average of the top 50%.
eg. %'s are in this order:
40%
23%
60%
90%
8%
The % I want would be the average of the top half (ie. the average of 90%, 60%, 40%) which is 63.33%. I can't change the order the %'s sit on to rank them in order of high to low first.
eg. %'s are in this order:
40%
23%
60%
90%
8%
The % I want would be the average of the top half (ie. the average of 90%, 60%, 40%) which is 63.33%. I can't change the order the %'s sit on to rank them in order of high to low first.