G
Guest
I have the following data in a worksheet
i have 800 rows of differing values.
For any 1 row:
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?
this answer is for 1 row:
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
But I need to do this for 800 rows...
any help very much appreciated
thanks
i have 800 rows of differing values.
For any 1 row:
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?
this answer is for 1 row:
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
But I need to do this for 800 rows...
any help very much appreciated
thanks