How to get two middle values in a range

Giganews Newsgroups
Subject: How to get two middle values in a range
Posted by:  daniel.ba…@gmail.com
Date: Wed, 4 Mar 2009

Hi!

I want to get two middle values from below range. I want the 1st
middle value to be given in cell A1 and the 2nd middle value to be
given in cell A2.

Range:
1, 2, 5, 3, 2, 4, 5, 2, 2, 3, 4, 2

Range sorted:
1
2
2
2
2
2 (1st middle value between 2 and 2)
3 (2nd middle value between 2 and 3)
3
4
4
5
5

Does anyone know what formula to use. I have been using quartile 2 and
quartile 3. Quartile 2 gives me the correct 1st middle value but
quartile 3 gives me incorrct 2nd middle value.

Thanks in advance.

Replies