Rank From Number

[muhammad susanto]

hi all...

how to make rank this layout below :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH]data1[/TH]
[TH]data2[/TH]
[TH]data3[/TH]
[TH][/TH]
[TH]expected result[/TH]
[TH]expected result[/TH]
[/TR]
[TR]
[TD]-58%[/TD]
[TD]-40%[/TD]
[TD]-64%[/TD]
[TD][/TD]
[TD]-40%[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-58%[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-64%[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

my target in 2 column ie. "expected result"

any helps, thank in advance.

.susanto

 

[Bo_Ry]

Please try
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH]data1[/TH]
[TH]data2[/TH]
[TH]data3[/TH]
[TH][/TH]
[TH]expected result[/TH]
[TH]expected result[/TH]
[/TR]
[TR]
[TD]-58%[/TD]
[TD]-40%[/TD]
[TD]-64%[/TD]
[TD][/TD]
[TD]=LARGE($A$2:$C$2,F2)[/TD]
[TD]=ROWS(F$2:F2)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-58%[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-64%[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]