Hello Forum Members,

I have been having a problem,
I have one column containing the time in minutes (E.G. 0,005)
In the next I have data ranging from 0 to 2
Because of the fast amount of data I have I want to create a new column with a median value for every half minute.
I tried doing this with a {=MEDIAN(IF(TIME<0,5;DATA Column;""))} but this does not give me any good result.
The resulting value for the first half minute using this formula is 0,034 while it should be 0,125.
Can anyone help me with this problem?