Sorting Columns Values question

D

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
 
G

Glenn

dab said:
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)
 
D

dab

Glenn said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top