percentile function with if

A

anjem

I tried to place a nested if function to only get the percentile o
certain values in a data range, but this doesn't work. Ex. get the 25t
and 75th percentiles for all values in the 1st group, but not includin
any values in the second group. Is there another way to do this
 
F

Frank Kabel

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER)
=PERCENTILE(IF(A1:A100="1st group",B1:B100),0.25)

Assumptions:
- col. A contains your group name
- col. B the values
 
Top