Place numbers in ascending order

[Pavel]

I have 2 columns as follows:
A B
Number Correct Order
1
3
5
6
2

I need to display the numbers from column A in ascending order in column B,
WITHOUT using the sort function!

Any tips please!

 

[Mike H]

Hi,

It looks like you unsorted range starts in a2 so put the formula in b2 and
drag down

=SMALL(A:A,ROW(A1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Pavel]

Hi Mike

Excellent job
My actuall formula should refer to absolute cell reference but that was it!

Thanks again