How to extract sorted row & ...

G

getlinkdeep

Joined
Nov 11, 2006
Messages
2
Reaction score
0
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
 
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
 
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
 
Back
Top