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