I need to compare 3 numbers and find the one in the middle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three numbers in a single row and would like to identify the middle
number enter that number in another cell.

Example:

1st # 2nd # 3rd # result
628 678 720 678
655 625 700 655
748 720 725 725

is there a function in excel that can do this?

Thanks,

Eddie
 
fasteddie wrote...
I have three numbers in a single row and would like to identify the middle
number enter that number in another cell.
Click to expand...
....

=MEDIAN(A2:C2)
 
Thank you both of your answers worked great. I had tried the MEDIAN function
but for some reason in the worksheet I had exported it would not calculate.
I created another worksheet and it worked.

Thank you for your help!!!

Eddie
 

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

How to enter start and end date/time in excel based on some specific value. 7
Highest number in the middle, descending numbers to left and right 0
Excel How to find the most common pairs and triplets numbers? 5
LOOKUP value in a table and return value in first column of same r 2
LOOKUP across a whole table and not just first row or column 4
I need to round in the middle of a formula 1
I need elegance..... 10
need to compare dates and count the results 2

Back
Top