Results 1 to 3 of 3

Thread: Take Percentile if between certain date range

  1. #1

    Take Percentile if between certain date range



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #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. #3
    Quote Originally Posted by Rizky View Post
    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
  •