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

[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

 

[VBA Noob]

Try

=LARGE(A1:C1,2)

VBA Noo

 

[Harlan Grove]

fasteddie wrote...

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

....

=MEDIAN(A2:C2)

 

[Guest]

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

 

[Guest]

=median(A1:A3)