You have to use an array formula. For example type the
following into a cell
=MIN(A2:A6-B2:B6)
And then instead of pressing Enter, press Shift + Enter
This will enter it as an array formula and you will see
that it now has {} around it
={MIN(A2:A6-B2:B6)}
-----Original Message-----
Hi there,
I have two columns of data before and after and event
and
I want to find the median, min, max and quartiles of the
change that has occured (after - before). I can easily
make another column to calculate the differences and
perform the statistics very easily. I already have a
lot
of columns so I wanted to find ways of saving space and
since this is a calculation that I do for a number of
variables it would certainly free up columns for me. I
have found functions such as sumx2py2 that act in the
way
that I am looking for, but I do not need to find the sum
of the squared differences, I just want to find the
minimum of the differences. Are there functions in
Excel
that can do this?
Many thanks
Tim Archer
.
|