Formula for dynamic data organiztion

D

Dr_Gzus

I apologize if the title is cryptic... I've been at this for days an
I've tried so many formula combinations that I'm not sure what to cal
this anymore.

The attached sheet probably explains it best, but basically I have
dynamically updating spreadsheet that allows end-user-defined attribute
+ categories for those attributes, and their definitions and placemen
are all user-driven. The end result is the percentage-ordered doughnu
chart that has weighted categories as the base and the attribute score
that comprise each category encircling it. (I know, pies and doughnut
are bad, bad, bad).

I need to get the attribute scores sorted by (1) category weight the
(2) high to low... AND aligned in ONE column. Plus I need the attribut
names next to the ordered data so I can make the chart. What formulas d
I need in the two right-most columns?

Thanks!

Edit: I have the first two columns under "What I want" figured ou
already

+-------------------------------------------------------------------
|Filename: Ordering_Help!.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=420
+-------------------------------------------------------------------
 

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