Sorting & Connecting with formula (excel 2013)

Hi everyone,

I have a (from my perspective ) really complicated question. I hope one of you can help me on this.
I have a list with different categories and several characteristics per category.
My goal is to identify the 10 strongest growing characteristics (I guess by sorting them in descending order) and then show them in this order, but organized in the respective categories.
e.g.: if "Psychographic">"Demographic" and "geographic" and "behavioralistic", then put "Psychographic, including its subordinated characteristics that are included in the top 10, first.
Follow this order until all Top10 members are included.

It is super hard to explain it in words, but maybe the screenshot below can help

I would be super grateful for any help!!!
Thanks,
Sabini

Hi Sabini

What screenshot ?

Regards
Alastair

HI Alastair,

sorry, I accidently published this post twice and didnt understand how to delete it.
Please find the correct one here: http://www.excelforum.com/excel-form...ml#post3545072
There you can also find the excel file.

Thanks a lot for your help,
Sabini