If you want to do it in the same cell then you have to go for a Macro
Solution, if you would like to use a helper column to do it, then use the
below method.

Assume that you are having the below Numbers in A Column

A Col
1
2
6
7
3
4
22
21

Paste this formula in B1 cell
=IF(ISERROR(SMALL(A:A,ROW(A1))),"END OF RESULT",SMALL(A:A,ROW(A1)))

Now copy the B1 cell formula and paste it to the remaining cells of B Column
Based on the A Column Data.

If you dont want to show the Cell as Blank instead of the End of Result
Message use the below one.
=IF(ISERROR(SMALL(A:A,ROW(A1))),"",SMALL(A:A,ROW(A 1)))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Fareez" wrote:

Dear All
I have sorted (ascending order)following numbers.
1
2
4
5
if i enter 3 below 5, is there any way to bring automatically 3 below 2
(ascending order)
thanks