Median array formula

C

Ciara

Hi
I have had a look at the median posts and array posts but I am really
struggling with this as I have never built an array before.

I need to find the median length of stay for age/Psex/admissiontype for
each HRG (column A)
I have the following columns of data
A B C D E
F
HRG AgeRange PSex AdmissionType LOS Median LOS
A11 0-14 Male Elective 14
{ARRAY FORMULA??}

I imagine the formula with have to lookup colum G concatenation of
A2&B2&C2&D2 within the range of data (a2:e:100), then find the median
of those results? I just don't know how to put this together or if it
is possible the way I have the dataset laid out. Thanks for you help.
 
C

Ciara

Nevermind... I think I got it. Was less scary than I thought.
{=MEDIAN(IF($A$2:$A$2539=A2,$G$2:$G$2539))}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
median array help 2
Help in Median of a quartile 4
median if 4
Median Formula not working properly 2
Median with Criteria 2
Percentile 1
Percentile 0

Top