Ascending order

[Winehouse]

Hi

I’ve got a column of numbers starting in N4 for example

7
1
25
22
34
30

In the next column starting in O4, i’d like to place them in ascending order

1
7
22
25
30
34

I can’t work out how to do this.

Any help is very much appreciated.

Regards

 

[Marcelo Branco]

Maybe...

O3
=MAX(1,MATCH(1,INDEX(--ISNA(MATCH(ROW($A$1:$A$1000)-ROW(A$1)+1,N$4:N$200,0)),),0)-1)

M.