Hi
I have a large data set looking at patient outcomes (length of stay in hospital) and want to break it down by month.
I am trying to calculate the median of a column (column I - the number of days in hospital) based on the text in a different column (column D - month e.g. Feb-24, Jan-24, Dec-23 etc)
I have tried to use "=MEDIAN(IF(D:D="Feb-24", I:I))" but I just get a #NUM error!
Can anyone please tell me what I am doing wrong?
Thanks in advance!