Need help with formula when data changes in column

[lee009]

I have a sheet with thousands of rows of data. I have one column with different 'stations'. For example, column D is where my stations are and the data is 1A, 1B, 1C, 2A, 2B, 2C, etc. Each station has approximately 1500 rows/incidents of data that pertains to it. One of the columns associated with each row is a time field. I have to find the median time for each station, for all its incidents. Is there a formula I can use that essentially states give me the median for all stations in column D and separate each station as it changes in the column? For example, 'station' 1A might have 1400 incidents with 1400 different times; 'station' 1B might have 1350 incidents with 1350 different times.

Looking for an easy formula that will get the median for each 'station'

 

[Asala42]

I'd probably use an array formula (easy one).

{=MEDIAN(IF($D$2:$D$20000=Z1,$E$2:$E$20000))}

Where:
D2:D20000 is your range of station names
E2:E20000 is your range of station times
Z1 is a specific station name (eg "1A")

Note this is an array formula. Hit "Ctrl+Shift+Enter" to get the {} brackets.