EXCEL automatic sorting

How to EXCEL an all cells within the three-digit, automatically from big to small, or small to large order? My objective is to find in the middle of three-digit number.

This is not What you wrote the formula

Khan ……

data in column A, B1 = large (A $ 1:A $ 3, row ()), the drop-down

that understand the point, not sure you mean.

You said the median should be the right, directly MEDIAN function.For example, your three-digit unit cell is A1:A3, to write the formula “= MEDIAN (A1:A3)” can be.Try it, what problems ask it, I wish you success!

You can use the formula