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
+-------------------------------------------------------------------
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
+-------------------------------------------------------------------