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
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