percentile function with if

  • Thread starter Thread starter anjem
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fina number of records between 2 percentile values 2
percentile function 1
Calculating percentiles 1
Look up & auto populate between sheets 7
Auto fill cell based upon another cell value 3
percentile markers or boxplot on excel scatter graph 2
"Undefined Function" in Expression when using VBA module in query 1
Bubble Chart best fit Scatter plot 3

Back
Top