How to extract sorted row & ...

[getlinkdeep]

Hi

Hope to have some help here regarding Excel sorting
I have the following data :-

Raw Data Sorted Data
Math Science History Biology Chemistry History Science Chemistry
12% 45% 56% 15% 28% 56% 45% 28%

I am looking for an Excel formula to achieve the "Sorted Data" on the right.
Right now, I am doing manually.
Is there an easy way to do that.

Thks

 

[bodhi]

Does your school report say "must try harder"? haha.

Right, anyway........what do you want the data sorted by? Do you just want the same data but in assending order?

Bodhi

 

[getlinkdeep]

Hi

Perhap I did not put it correctly. I am using that data as an illlustration ... I am not into any school stuffs.
What actually I wanted was to sort the data A in row & have an Excel formula to display from descending order (also in row form) to right side ...
(See Data B)
I hope to have some Excel formula that can do it automatically so that I can cut down my time doing this report. Btw, the actual data consists of 100 products.
I need to priortise in descending order and in row display.
Below is just a example.
Thanks

DATA A DATA B
NG A NG B NG C NG D -----> NG B NG D NG C
Product A 12 90 42 60 90 60 42
NG C NG B NG D
Product B 5 43 100 20 -----> 100 43 20