Ciao everyone.
i've searched some already existing question like this without any result, so here my first topic.
sorry for my english, i know is not really good.
I have a column of vallue calculated from other cells operations.
i have to find a way to create a new list of them oredere from the higest to the lower, in an authomatic way.
Some suggestions?
here below that i means...
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]name[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="class: xl66, width: 128, colspan: 2"] result list[/TD]
[TD="class: xl67, width: 64"]order
[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl64"]carlo[/TD]
[TD="class: xl63, align: right"]60[/TD]
[TD="class: xl65, align: right"]50[/TD]
[TD="class: xl64, colspan: 2"] 110[/TD]
[TD="class: xl67"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"]ciccia[/TD]
[TD="class: xl63, align: right"]100[/TD]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl64, colspan: 2"] 120[/TD]
[TD="class: xl67"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"]puddu[/TD]
[TD="class: xl63, align: right"]45[/TD]
[TD="class: xl65, align: right"]100[/TD]
[TD="class: xl64, colspan: 2"] 145[/TD]
[TD="class: xl67"]5[/TD]
[TD="class: xl68"]value list[/TD]
[/TR]
[TR]
[TD="class: xl64"]aaa[/TD]
[TD="class: xl63, align: right"]55[/TD]
[TD="class: xl65, align: right"]31[/TD]
[TD="class: xl64, colspan: 2"] 86[/TD]
[TD="class: xl67"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"]ddd[/TD]
[TD="class: xl63, align: right"]12[/TD]
[TD="class: xl65, align: right"]24[/TD]
[TD="class: xl64, colspan: 2"] 36[/TD]
[TD="class: xl67"]1[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
------------------------------------------------------------------
[TABLE="width: 576"]
<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]name[/TD]
[TD="class: xl65, width: 64"]order[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65"]ddd[/TD]
[TD="class: xl65, align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]aaa[/TD]
[TD="class: xl65, align: right"]2[/TD]
[TD][/TD]
[TD="colspan: 3"]final automatic result i need[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]carlo[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]ciccia[/TD]
[TD="class: xl65, align: right"]4[/TD]
[TD][/TD]
[TD="colspan: 6"](it should be refresced avery time the value list change)[/TD]
[/TR]
[TR]
[TD="class: xl65"]puddu[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advances to anyone.
i've searched some already existing question like this without any result, so here my first topic.
sorry for my english, i know is not really good.
I have a column of vallue calculated from other cells operations.
i have to find a way to create a new list of them oredere from the higest to the lower, in an authomatic way.
Some suggestions?
here below that i means...
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]name[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="class: xl66, width: 128, colspan: 2"] result list[/TD]
[TD="class: xl67, width: 64"]order
[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl64"]carlo[/TD]
[TD="class: xl63, align: right"]60[/TD]
[TD="class: xl65, align: right"]50[/TD]
[TD="class: xl64, colspan: 2"] 110[/TD]
[TD="class: xl67"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"]ciccia[/TD]
[TD="class: xl63, align: right"]100[/TD]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl64, colspan: 2"] 120[/TD]
[TD="class: xl67"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"]puddu[/TD]
[TD="class: xl63, align: right"]45[/TD]
[TD="class: xl65, align: right"]100[/TD]
[TD="class: xl64, colspan: 2"] 145[/TD]
[TD="class: xl67"]5[/TD]
[TD="class: xl68"]value list[/TD]
[/TR]
[TR]
[TD="class: xl64"]aaa[/TD]
[TD="class: xl63, align: right"]55[/TD]
[TD="class: xl65, align: right"]31[/TD]
[TD="class: xl64, colspan: 2"] 86[/TD]
[TD="class: xl67"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"]ddd[/TD]
[TD="class: xl63, align: right"]12[/TD]
[TD="class: xl65, align: right"]24[/TD]
[TD="class: xl64, colspan: 2"] 36[/TD]
[TD="class: xl67"]1[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
------------------------------------------------------------------
[TABLE="width: 576"]
<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]name[/TD]
[TD="class: xl65, width: 64"]order[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65"]ddd[/TD]
[TD="class: xl65, align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]aaa[/TD]
[TD="class: xl65, align: right"]2[/TD]
[TD][/TD]
[TD="colspan: 3"]final automatic result i need[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]carlo[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]ciccia[/TD]
[TD="class: xl65, align: right"]4[/TD]
[TD][/TD]
[TD="colspan: 6"](it should be refresced avery time the value list change)[/TD]
[/TR]
[TR]
[TD="class: xl65"]puddu[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advances to anyone.