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