Hi Guys,
Need your expertise on creating the formula in attached file, have been playing with averageif but no result due to multiple criteria , hope someone can enlighten me on this problem.
Attached file below contain the sample and remark which makes it easier to understand rather than me explaining it here. Please feel free to ask me any question if anything unclear
Thanks in advance for the help.
Top and Bottom 10%.xlsb
Bookmarks