Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |