Need help with my calculation on 95th and 50th percentiles.

acoron01

New member
Joined
Aug 7, 2013
Messages
4
Reaction score
0
Points
0
Hello i am new to excel, i need help with my calculation, im not too familiar with the syntax and the percentile function. My calculation calculates every percentile in 'Group', but i dont want it to, i need it to calculate every percentile in each subgroup (ID) in each 'Group'. Can someone please point me in the right direction ? View attachment Copy of Copy of EXAMPLE1 (2).xlsx
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Try this array formula

=PERCENTILE(IF(C2:C10="SW",F2:F10),0.95)
 
Top