Get the summary automtically based on Data

Hello,

Need one help.....I need to get the all summary details automatically based on the "raw data" provided. Currently i m doing it by using pivot and updated the result as well. Please help me in getting the same result by using formulas. Atttached the samples.

For column H, try this:
=MAXIFS($C$3:$C$91,$B$3:$B$91,$F5)

Column I:
=MINIFS($C$3:$C$91,$B$3:$B$91,$F5,$C$3:$C$91,">"&0)

Column J:
=AVERAGEIFS($C$3:$C$91,$B$3:$B$91,$F5,$C$3:$C$91,">"&0)

For Column G, I don't know how to get the count if you need to remove duplicates. Sorry.

Thanks for sharing the formula..
Here only Average formula works fine.....for rest getting the result as #Name?

i request any expert to help on all these formulas...Thanks in advance

Thanks a lot for your help...Its working fine....can i get the unique Levels (updated manually from F5:F9) by using formula?

Oh..Thats really working well...Thanks for your help...lengthy formula..need time to understand

Hello,

in the below formula, if i change the range from B91 to 5000, it does not work can you please help.

=IFERROR(INDEX($B$3:$B$91,MOD(AGGREGATE(15,6,ROW($B$1:$B$99999)/(FREQUENCY(COUNTIF($B$3:$B$91,"<="&$B$3:$B$91)*1000+MATCH($B$3:$B$91,$B$3:$B$91,),ROW($B$1:$B$99999))>0),ROWS(F$5:F5)),1000)),"")

Thanks a lot ,,,now its working with large range as well..