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