# Thread: Take Percentile if between certain date range

1. ## Take Percentile if between certain date range

I'd like to take the 90th Percentile of the test scores (Column B) that fall between a certain date range (Column A).

Example: Take 90th percentile of scores that fall between 12/30/2015 and 12/27/2015
Dates (A) Scores (B)
12/31/2015 95
12/30/2015 96
12/29/2015 71
12/28/2015 82
12/27/2015 77
12/26/2015 61

I (unsuccessfully) came up with: =PERCENTILE(IF(A:A>DATEVALUE("12/27/2015"),IF(A:A<DATEVALUE("12/30/2014"),IF(B:B<>"",B:B))),0.9)

FOR THE LOVE OF GOD HELP ME

2. Try to limit your ranges and yjis is array formula type, so you need to press CTRL+SHIFT+ENTER button all together, ENTER alone don't works

=PERCENTILE(IF(\$A\$2:\$A\$7>=DATEVALUE("2015/12/27"),IF(\$A\$2:\$A\$7<=DATEVALUE("2015/12/30"),\$B\$2:\$B\$7)),0.9)

3. Originally Posted by Rizky
Try to limit your ranges and yjis is array formula type, so you need to press CTRL+SHIFT+ENTER button all together, ENTER alone don't works

=PERCENTILE(IF(\$A\$2:\$A\$7>=DATEVALUE("2015/12/27"),IF(\$A\$2:\$A\$7<=DATEVALUE("2015/12/30"),\$B\$2:\$B\$7)),0.9)
It worked! Thank you kind stranger.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•