Sort data
 

Hi all

Have following question/problem to solve:
col : A B C D E F G H I
row1 : 100 101 102 103 104 105 106 107 108
row2: 2 8 5 7 8 2 9 5 4

Need to sort the rows in a way that the result is as follows:

col : A B C D E F G H I
row1 : 106 104 101 103 107 102 108 105 100
row2: 9 8 8 7 5 5 4 2 2

Is there any way to do this??

Tks in advance
António

Sort data
 

Hi,

Select the data and then

Data|Sort - Options Button - select 'left to right' - OK select Row 2-
'Descending ' and do the sort
--
Mike

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


"Antonio" wrote:

Hi all

Have following question/problem to solve:
col : A B C D E F G H I
row1 : 100 101 102 103 104 105 106 107 108
row2: 2 8 5 7 8 2 9 5 4

Need to sort the rows in a way that the result is as follows:

col : A B C D E F G H I
row1 : 106 104 101 103 107 102 108 105 100
row2: 9 8 8 7 5 5 4 2 2

Is there any way to do this??

Tks in advance
António

Sort data
 

It's just the sort facility but it needs adjustment to do it laterally.

Select your range - Data tab - sort - options - sort left to right - ok -
sort by - row 2 - values - largest to smallest - add level - then by - row 1
- values - largest to smallest - ok.

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Antonio" wrote:

Hi all

Have following question/problem to solve:
col : A B C D E F G H I
row1 : 100 101 102 103 104 105 106 107 108
row2: 2 8 5 7 8 2 9 5 4

Need to sort the rows in a way that the result is as follows:

col : A B C D E F G H I
row1 : 106 104 101 103 107 102 108 105 100
row2: 9 8 8 7 5 5 4 2 2

Is there any way to do this??

Tks in advance
António

Sort data
 

Named range
champ1 $A$1:$I$1
champ2 $A$2:$I$2

B5:=Large(champ2,Columns($A:A))
Valid with Shift+ctrl+enter

A5:=INDEX(champ1,Large(If(champ2=A6,Column($A:
$I)),Countif($A6:A6,A6)))
Valid with Shift+ctrl+enter

http://cjoint.com/?efsRBOJAb5

JB
http://boisgontierjacques.free.fr/

On 5 avr, 18:06, Antonio wrote:
Hi all

Have following question/problem to solve:
col * *: * A * * B * * *C * * D * * E * * *F * * G * * H * * *I
row1 : 100 *101 *102 *103 *104 *105 *106 *107 *108
row2: * *2 * * 8 * * *5 * * *7 * * 8 * * *2 * * 9 * * *5 * * 4

Need to sort the rows in a way that the result is as follows:

col * *: * A * * B * * *C * * D * * E * * *F * * G * * H * * *I
row1 : 106 *104 *101 *103 *107 *102 *108 *105 *100
row2: * *9 * * *8 * * 8 * * 7 * * *5 * * 5 * * *4 * * *2 * * 2

Is there any way to do this??

Tks in advance
António