Using Median to get the median of seconds per day per checkpoint

Hi,

I have a data set where i am trying to get the median of seconds per checkpoint per day, where i have multiple results per day. From what i can see i would want to use "MEDIAN" in conjuction with an "IF" statement but am horribly stumped.

Any suggestions or advise would be greatly appreciated.

MEDIAN SAMPLE.xlsx

Originally Posted by dodgerpixie

i have a data set where i am trying to get the median of seconds per checkpoint per day, where i have multiple results per day.
[....]
Attachment 352026

Array-enter (press ctrl+shift+Enter instead of just Enter) the following formula into D2 and copy down through D17:

=if(b2=b1,"",median(if($b$2:$b$17=b2,$c$2:$c$17)))

That assumes you want to see the median only once per checkpoint.

[EDIT] Note: You can change the ranges to $B$2:$B$1000 and $C$2:$C$1000 if you want to allow for an ever-changing number of checkpoints.