Place numbers in ascending order

  • Thread starter Thread starter Pavel
  • Start date Start date
P

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!
 
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.
 
Hi Mike

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

Thanks again
 
Back
Top