rexysri
New Member
- Joined
- Mar 2, 2016
- Messages
- 27
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- Platform
- Windows
- Mobile
i am using this formula =AVERAGE(LARGE(IF('Stu List'!$F$3:$F$1322=$E$1,'Stu List'!$K$3:$K$1322),ROW(1:5))) for Average large 5 and 10 values it's working, but when i am trying to average small 5 values ignoring blank cells its not working AVERAGE(SMALL(IF('Stu List'!$F$3:$F$1322=$E$1,'Stu List'!$K$3:$K$1322),ROW(1:5)))
CAN ANY ONE HELP..
CAN ANY ONE HELP..