Do you want the output in one single cell or in 2 separate cells?


Mike Wrote:
Hi everyone,

Say I have a dat set such as:

4
5
6
7

The median is (5+6)/2=5.5!

However, I am not interested in the answer here, but the 5 and the
6!!!

Is there an excel function or way to do so?

Thanks alot,
Mike


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390763