Re: excel sorting task

Ian,

Try this

A2: =B1
B2: =B1

then copy across as many columns as you need

then sort rows 1 and 2 with row 2 as the sort by row

--
HTH

Bob Phillips

"Ian" <Ian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54B14FC4-EC49-4B43-B248-A15778CE2F2A@xxxxxxxxxxxxxxxx
> I have the following data in a work***
> Important note: it is in pairs, that is columns A,B is pair 1, C,D is pair
> 2, E,F is pair 3.
>
> i want to sort it WITHIN ROW on columns b,d,f, with the smallest value in
> b,d or f first then the next largest then the largest.
>
> For example
> A B C D E F
> 5 12 2 3 1 6
>
> would become
> A B C D E F
> 2 3 1 6 5 12
>
> b=3
> d=6
> f=12
> this is what i want, the pairs sorted in ascending order for b,d,f for a
> given row.
> is this possible?
>
> i'm thinking nested IF statements.......??? but im not sure
>
> any help very much appreciated
>
> thanks


.

Loading