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>

data1	data2	data3		expected result	expected result
-58%	-40%	-64%		-40%	1
				-58%	2
				-64%	3

<tbody>
</tbody>

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>

data1	data2	data3		expected result	expected result
-58%	-40%	-64%		=LARGE($A$2:$C$2,F2)	=ROWS(F$2:F2)
				-58%	2
				-64%	3

<tbody>
</tbody>