Function that helps me find the middle value

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

Hi,

I need a function that helps find the middle value. For example, if I
have 12, 23 and 100, it must show 23. Or if I have 1,2,3 must show 2.

Thanks
 
Here's a generalised solution to the problem:

=LARGE(A1:A10,ROUNDUP(COUNT(A1:A10)/2,0))

Your numbers can be anywhere in the range A1:A10 (as an example), and
works best if you have an odd number of numbers.

Hope this helps.

Pete
 
Back
Top