Sort data

[Antonio]

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

 

[Mike H]

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.

 

[JB]

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/