Sorting Columns Values question
 

Good day,
I have the following table:

A B C
Blue 50 25 15
Red 10 5 32
Green 6 45 12

After sorting, I need the result to give me something like this:

A B C
Blue 50 25 15
Red 32 10 5
Green 45 12 6

Which means that will maintain row integrity but it will re-arrange the
values decreasing from A to C
Any help will be appreciated.
Thanks

Sorting Columns Values question
 

dab wrote:
Good day,
I have the following table:

A B C
Blue 50 25 15
Red 10 5 32
Green 6 45 12

After sorting, I need the result to give me something like this:

A B C
Blue 50 25 15
Red 32 10 5
Green 45 12 6

Which means that will maintain row integrity but it will re-arrange the
values decreasing from A to C
Any help will be appreciated.
Thanks


You could sort each row individually in descending order, or assuming your data
is in A1:D4, put the following in F2 and copy down and across to H4:

=LARGE($B2:$D2,COUNT($B2:$D2)+COLUMN()-8)

Sorting Columns Values question
 

"Glenn" wrote:

dab wrote:
Good day,
I have the following table:

A B C
Blue 50 25 15
Red 10 5 32
Green 6 45 12

After sorting, I need the result to give me something like this:

A B C
Blue 50 25 15
Red 32 10 5
Green 45 12 6

Which means that will maintain row integrity but it will re-arrange the
values decreasing from A to C
Any help will be appreciated.
Thanks


You could sort each row individually in descending order, or assuming your data
is in A1:D4, put the following in F2 and copy down and across to H4:

=LARGE($B2:$D2,COUNT($B2:$D2)+COLUMN()-8)

Hello Glen
Thanks for the tip.
I did the sorting by row and I've got the proper result.
Regards