Function that helps me find the middle value

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
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for a sum! 4
How can I find paragraph breaks that are not preceded by a period? 0
Calculate the median value before a specified list 0
Word macro that can call cells out of Excel for a find and replace 0
Excel - Wich Function should I use? 1
Function to Combine Names and Middle Initital In Various Formats 3
Combining three files when middle file has sections with endnotes 2
How to get two middle values in a range 4

Top