ordenar tabla automaticamente

bpxss

New Member
Joined
Mar 11, 2011
Messages
17
pts
equipo 1 7
equipo 2 5
equipo 3 3
equipo 4 3

la formula que uso es =K.ESIMO.MAYOR($R$5:$R$8;FILA()-4) y se refiere a una tabla auxiliar

me ordena automaticamente los puntos que surgen a su vez de otra tabla pero lo que no ordena es el nombre de los equipos, si uso la misma formula para la celda de los equipos sucede que si hay equipos con el mismo puntaje, estas celdas toman el mismo nombre. Espero que se entienda ya que no puedo insertar el archivo adjunto. No hay muchas opciones para poder explicar bien el problema.
 
Last edited:

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,317
Hola,

Introduzca a la izquierda de la tabla de resultados una coluna auxiliar, por ejemplo en la columna P, ponendo en P5 la siguiente fórmula
(formulas en Inglés)
=COUNTIF($R$5:$R$9,"<"&R5)+COUNTIF($R5:$R$9,R5)

<TABLE style="WIDTH: 194pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=258><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=64></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; WIDTH: 50pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=66>P</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=64>Q</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=64>R</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Equipo1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>10</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Equipo2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>12</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Equipo3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>10</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Equipo4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>11</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Equipo5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>10</TD></TR></TBODY></TABLE>

Después

<TABLE style="WIDTH: 164pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=218><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=20 width=64></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=90>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>Classificación</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>Puntos</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>Equipo2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 align=right>12</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>Equipo4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 align=right>11</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>Equipo1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 align=right>10</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>Equipo3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 align=right>10</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>Equipo5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 align=right>10</TD></TR></TBODY></TABLE>

Formula en A5
=VLOOKUP(LARGE($P$5:$P$9,ROW()-4),$P$5:$R$9,2,0)
copia para bajo (copy down)

Formula en B5
=VLOOKUP(LARGE($P$5:$P$9,ROW()-4),$P$5:$R$9,3,0)
copia para bajo (copy down)

Espero que ayude

M.
 

bpxss

New Member
Joined
Mar 11, 2011
Messages
17
muchas gracias por responder, de todas maneras preferiria mi mismo ejemplo y las formulas en español, pero igualmente gracias

<table border="0" cellpadding="0" cellspacing="0" width="835"><col style="width: 59pt;" width="78"> <col style="width: 205pt;" width="273"> <col style="width: 30pt;" width="40"> <col style="width: 23pt;" span="4" width="31"> <col style="width: 24pt;" span="10" width="32"> <tbody><tr style="height: 16.5pt;" height="22"> <td class="xl68" style="height: 16.5pt; width: 59pt;" height="22" width="78">Equipo</td> <td class="xl69" style="width: 205pt;" width="273">Pts</td> <td class="xl69" style="width: 30pt;" width="40">5ª</td> <td class="xl69" style="width: 23pt;" width="31">6ª</td> <td class="xl69" style="width: 23pt;" width="31">7ª</td> <td class="xl69" style="width: 23pt;" width="31">8ª</td> <td class="xl69" style="width: 23pt;" width="31">9ª</td> <td class="xl69" style="width: 24pt;" width="32">10ª</td> <td class="xl69" style="width: 24pt;" width="32">11ª</td> <td class="xl69" style="width: 24pt;" width="32">12ª</td> <td class="xl69" style="width: 24pt;" width="32">13ª</td> <td class="xl69" style="width: 24pt;" width="32">14ª</td> <td class="xl69" style="width: 24pt;" width="32">15ª</td> <td class="xl69" style="width: 24pt;" width="32">16ª</td> <td class="xl69" style="width: 24pt;" width="32">17ª</td> <td class="xl69" style="width: 24pt;" width="32">18ª</td> <td class="xl69" style="width: 24pt;" width="32">19ª</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 1
</td> <td class="xl69" style="font-size: 10pt; color: rgb(255, 192, 0); font-weight: 700; text-decoration: none; font-family: "Arial Black";">31 (sumatoria de 5ª a 19ª)
</td> <td class="xl71" style="font-size: 10pt; color: rgb(255, 192, 0); font-weight: 700; text-decoration: none; font-family: Arial;">31</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 2
</td> <td class="xl69">30</td> <td class="xl71">30</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 3
</td> <td class="xl69">26</td> <td class="xl71">26</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 4
</td> <td class="xl69">22</td> <td class="xl71">22</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 5
</td> <td class="xl69">22</td> <td class="xl71">22</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 6
</td> <td class="xl69">16</td> <td class="xl71">16</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 7
</td> <td class="xl69">15</td> <td class="xl71">15</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 8
</td> <td class="xl69">11</td> <td class="xl71">11</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 9
</td> <td class="xl69">10</td> <td class="xl71">10</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> </tbody></table>
necesito que me ordene todas las filas no solo la que contiene la sumatoria
 

bpxss

New Member
Joined
Mar 11, 2011
Messages
17
muchas gracias por responder, de todas maneras preferiria mi mismo ejemplo y las formulas en español, pero igualmente gracias

<table border="0" cellpadding="0" cellspacing="0" width="835"><col style="width: 59pt;" width="78"> <col style="width: 205pt;" width="273"> <col style="width: 30pt;" width="40"> <col style="width: 23pt;" span="4" width="31"> <col style="width: 24pt;" span="10" width="32"> <tbody><tr style="height: 16.5pt;" height="22"> <td class="xl68" style="height: 16.5pt; width: 59pt;" height="22" width="78">Equipo</td> <td class="xl69" style="width: 205pt;" width="273">Pts</td> <td class="xl69" style="width: 30pt;" width="40">5ª</td> <td class="xl69" style="width: 23pt;" width="31">6ª</td> <td class="xl69" style="width: 23pt;" width="31">7ª</td> <td class="xl69" style="width: 23pt;" width="31">8ª</td> <td class="xl69" style="width: 23pt;" width="31">9ª</td> <td class="xl69" style="width: 24pt;" width="32">10ª</td> <td class="xl69" style="width: 24pt;" width="32">11ª</td> <td class="xl69" style="width: 24pt;" width="32">12ª</td> <td class="xl69" style="width: 24pt;" width="32">13ª</td> <td class="xl69" style="width: 24pt;" width="32">14ª</td> <td class="xl69" style="width: 24pt;" width="32">15ª</td> <td class="xl69" style="width: 24pt;" width="32">16ª</td> <td class="xl69" style="width: 24pt;" width="32">17ª</td> <td class="xl69" style="width: 24pt;" width="32">18ª</td> <td class="xl69" style="width: 24pt;" width="32">19ª</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 1
</td> <td class="xl69" style="font-size: 10pt; color: rgb(255, 192, 0); font-weight: 700; text-decoration: none; font-family: "Arial Black";">31 (sumatoria de 5ª a 19ª)
</td> <td class="xl71" style="font-size: 10pt; color: rgb(255, 192, 0); font-weight: 700; text-decoration: none; font-family: Arial;">31</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 2
</td> <td class="xl69">30</td> <td class="xl71">30</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 3
</td> <td class="xl69">26</td> <td class="xl71">26</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 4
</td> <td class="xl69">22</td> <td class="xl71">22</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 5
</td> <td class="xl69">22</td> <td class="xl71">22</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 6
</td> <td class="xl69">16</td> <td class="xl71">16</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 7
</td> <td class="xl69">15</td> <td class="xl71">15</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 8
</td> <td class="xl69">11</td> <td class="xl71">11</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> <tr style="height: 16.5pt;" height="22"> <td class="xl70" style="height: 16.5pt;" height="22">Equipo 9
</td> <td class="xl69">10</td> <td class="xl71">10</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> <td class="xl71" style="font-size: 10pt; color: rgb(148, 139, 84); font-weight: 700; text-decoration: none; font-family: Arial;">0</td> </tr> </tbody></table>
necesito que me ordene todas las filas no solo la que contiene la sumatoria. Los datos vienen de otra tabla auxiliar exactamente igual a esta.
 

bpxss

New Member
Joined
Mar 11, 2011
Messages
17
hola,

introduzca a la izquierda de la tabla de resultados una coluna auxiliar, por ejemplo en la columna p, ponendo en p5 la siguiente fórmula
(formulas en inglés)
=countif($r$5:$r$9,"<"&r5)+countif($r5:$r$9,r5)

<table style="width: 194pt; border-collapse: Collapse;" border="0" cellpadding="0" cellspacing="0" width="258"><colgroup><col style="width: 48pt;" width="64"><col style="width: 50pt;" width="66"><col style="width: 48pt;" span="2" width="64"></colgroup><tbody><tr style="height: 15pt;" height="20"><td style="border: 0.5pt solid windowtext; background-color: Rgb(197, 217, 241); width: 48pt; height: 15pt;" class="xl63" height="20" width="64">
</td><td style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: Solid solid solid none; border-color: Windowtext; background-color: Rgb(197, 217, 241); width: 50pt;" class="xl63" width="66">p</td><td style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: Solid solid solid none; border-color: Windowtext; background-color: Rgb(197, 217, 241); width: 48pt;" class="xl63" width="64">q</td><td style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: Solid solid solid none; border-color: Windowtext; background-color: Rgb(197, 217, 241); width: 48pt;" class="xl63" width="64">r</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl64" height="20">5</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Rgb(242, 242, 242);" class="xl65" align="right">3</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66">equipo1</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66" align="right">10</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl64" height="20">6</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Rgb(242, 242, 242);" class="xl65" align="right">5</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66">equipo2</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66" align="right">12</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl64" height="20">7</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Rgb(242, 242, 242);" class="xl65" align="right">2</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66">equipo3</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66" align="right">10</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl64" height="20">8</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Rgb(242, 242, 242);" class="xl65" align="right">4</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66">equipo4</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66" align="right">11</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl64" height="20">9</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Rgb(242, 242, 242);" class="xl65" align="right">1</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66">equipo5</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl66" align="right">10</td></tr></tbody></table>

después

<table style="width: 164pt; border-collapse: Collapse;" border="0" cellpadding="0" cellspacing="0" width="218"><colgroup><col style="width: 48pt;" width="64"><col style="width: 68pt;" width="90"><col style="width: 48pt;" width="64"></colgroup><tbody><tr style="height: 15pt;" height="20"><td style="border: 0.5pt solid windowtext; background-color: Transparent; width: 48pt; height: 15pt;" class="xl67" height="20" width="64">
</td><td style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: Solid solid solid none; border-color: Windowtext; background-color: Transparent; width: 68pt;" class="xl67" width="90">a</td><td style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: Solid solid solid none; border-color: Windowtext; background-color: Transparent; width: 48pt;" class="xl67" width="64">b</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl66" height="20">4</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Rgb(197, 217, 241);" class="xl65">classificación</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Rgb(197, 217, 241);" class="xl65">puntos</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl66" height="20">5</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67">equipo2</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67" align="right">12</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl66" height="20">6</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67">equipo4</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67" align="right">11</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl66" height="20">7</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67">equipo1</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67" align="right">10</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl66" height="20">8</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67">equipo3</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67" align="right">10</td></tr><tr style="height: 15pt;" height="20"><td style="border-width: Medium 0.5pt 0.5pt; border-style: None solid solid; border-color: Windowtext; background-color: Rgb(197, 217, 241); height: 15pt;" class="xl66" height="20">9</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67">equipo5</td><td style="border-width: Medium 0.5pt 0.5pt medium; border-style: None solid solid none; border-color: Windowtext; background-color: Transparent;" class="xl67" align="right">10</td></tr></tbody></table>

formula en a5
=vlookup(large($p$5:$p$9,row()-4),$p$5:$r$9,2,0)
copia para bajo (copy down)

formula en b5
=vlookup(large($p$5:$p$9,row()-4),$p$5:$r$9,3,0)
copia para bajo (copy down)

espero que ayude

m.
gracias, finalmente pude aplicarlo a mi ejemplo!!!
 

bpxss

New Member
Joined
Mar 11, 2011
Messages
17
Tengo la siguiente duda. Como Hago para que en L5 aparezca un 1 si la celda S4 deja de estar vacia y lo mismo para cuando las celdas S6 y S8 dejan de estar vacias. En total tendria que sumar 3 y si todas estan vacias no tendria que sumar nada. Le dejo la tabla en el link.

saludos

http://img694.imageshack.us/i/excelv.jpg/
 

Forum statistics

Threads
1,081,749
Messages
5,361,070
Members
400,612
Latest member
mr_sound

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top