Sorting Columns Values question

[dab]

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

 

[Glenn]

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 A14, put the following in F2 and copy down and across to H4:

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

 

[dab]

You could sort each row individually in descending order, or assuming your data
is in A14, 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