Median of differences between two columns??

  • Thread starter Thread starter ModelerGirl
  • Start date Start date
M

ModelerGirl

I have two columns and am taking the difference between the neighboring
cells in each row. I'd like to take a median of these differences.
For exampe, in columns A and B, I have

Row A B
1 10 17
2 100 3
3 25 31
4 10 20

I'd like to take the median of B1-A1, B2-A2, up to the last row (except
I have more like 28 rows)

Is there a way I can do this without computing the difference in a
separate column? I've looked at the Excel 2000 bible and haven't found
the answer. (Note that I have Excel 2003).

Thanks,

K.
 
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER)
=MEDIAN(B1:B28-A1:A28)

or if you only want to process the difference between both values you
may try the array formula
=MEDIAN(ABS(B1:B28-A1:A28))
 
Back
Top