Using Median with a look up function

**rgold** · 10-07-2008, 04:09 PM

Hello,
I have two columns of data

1st - Multiple physician names (may be duplicate as data set is Emergency Room encounters)

2nd - Denotes the length of stay in minutes for each patient encounter

I want to develop a formula to calculate the median length of stay (off 2nd col) for every physician a select in a drop down.

Thanks!

**martesoft** · 10-07-2008, 04:11 PM

=MEDIAN(IF(A2:A20="Physician",B2:B20))

this is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

**rgold** · 10-07-2008, 04:20 PM

Thank you for the prompt response. It worked!

Rob

**rgold** · 10-07-2008, 04:21 PM

Martesoft,
Quick question. How do you know when you have to use control+shift+enter and when you don't? Thanks.

Rob

**martesoft** · 10-08-2008, 02:37 AM

Basically, you eed to array-enter it if you use a range, an array, in a function that normally expects a single cell reference, like the IF in our example.