Prev: change XL2003 autofilter's arrow color
Next: Shared workbook-header not working
From: Pavel on 5 Feb 2010 07:38
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!
--
Its easier to learn thing than pretend you know it


From: Mike H on 5 Feb 2010 07:42
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" wrote:

> 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!
> --
> Its easier to learn thing than pretend you know it
>
>
From: Pavel on 5 Feb 2010 10:09
Hi Mike

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

Thanks again
--
Its easier to learn thing than pretend you know it


"Mike H" wrote:

> 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" wrote:
>
> > 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!
> > --
> > Its easier to learn thing than pretend you know it
> >
> >
 | 
Pages: 1
Prev: change XL2003 autofilter's arrow color
Next: Shared workbook-header not working