Hi,

I have one excel formula on 3rd percentile which i do not really understand.

Can Someone here help me?

IFERROR(AVERAGE(LARGE(IF(KBPS21!$A$2:$A$100=$A3,KBPS21!$B$2:$B$100),{1;3})),AVERAGEIFS(KBPS21!$B$2:$B$100,KBPS21!$A$2:$A$100,$A3))