Hi Pegleg,
I'd go with =RANK and =VLOOKUP, so you don't have to keep sorting each time...
something like this maybe :<TABLE BORDER="1" WIDTH="100%" BGCOLOR="white"><TR BGCOLOR="gray"><TD></TD><TD><CENTER>
A</CENTER></TD><TD><CENTER>
B</CENTER></TD><TD><CENTER>
C</CENTER></TD><TD><CENTER>
D</CENTER></TD><TD><CENTER>
E</CENTER></TD><TD><CENTER>
F</CENTER></TD><TD><CENTER>
G</CENTER></TD><TD><CENTER>
H</CENTER></TD><TD><CENTER>
I</CENTER></TD><TD><CENTER>
J</CENTER></TD></TR><TR><TD BGCOLOR="gray"><CENTER>
1</CENTER></TD><TD ALIGN="right">=RANK(C1,$C$1:$C$8,0)</TD><TD ALIGN="right">Team Blue</TD><TD ALIGN="right">255</TD><TD ALIGN="right"> </TD><TD ALIGN="right">1</TD><TD ALIGN="right">=VLOOKUP(E1,$A$1:$C$8,2,0)</TD><TD ALIGN="right">=VLOOKUP(E1,$A$1:$C$8,3,0)</TD><TD ALIGN="right">{--- copy down</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
2</CENTER></TD><TD ALIGN="right">=RANK(C2,$C$1:$C$8,0)</TD><TD ALIGN="right">Team Red</TD><TD ALIGN="right">326</TD><TD ALIGN="right"> </TD><TD ALIGN="right">2</TD><TD ALIGN="right">=VLOOKUP(E2,$A$1:$C$8,2,0)</TD><TD ALIGN="right">=VLOOKUP(E2,$A$1:$C$8,3,0)</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
3</CENTER></TD><TD ALIGN="right">=RANK(C3,$C$1:$C$8,0)</TD><TD ALIGN="right">Team Green</TD><TD ALIGN="right">612</TD><TD ALIGN="right"> </TD><TD ALIGN="right">3</TD><TD ALIGN="right">=VLOOKUP(E3,$A$1:$C$8,2,0)</TD><TD ALIGN="right">=VLOOKUP(E3,$A$1:$C$8,3,0)</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
4</CENTER></TD><TD ALIGN="right">=RANK(C4,$C$1:$C$8,0)</TD><TD ALIGN="right">Team Yellow</TD><TD ALIGN="right">554</TD><TD ALIGN="right"> </TD><TD ALIGN="right">4</TD><TD ALIGN="right">=VLOOKUP(E4,$A$1:$C$8,2,0)</TD><TD ALIGN="right">=VLOOKUP(E4,$A$1:$C$8,3,0)</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
5</CENTER></TD><TD ALIGN="right">=RANK(C5,$C$1:$C$8,0)</TD><TD ALIGN="right">Team Brown</TD><TD ALIGN="right">812</TD><TD ALIGN="right"> </TD><TD ALIGN="right">5</TD><TD ALIGN="right">=VLOOKUP(E5,$A$1:$C$8,2,0)</TD><TD ALIGN="right">=VLOOKUP(E5,$A$1:$C$8,3,0)</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
6</CENTER></TD><TD ALIGN="right">=RANK(C6,$C$1:$C$8,0)</TD><TD ALIGN="right">Team Orange</TD><TD ALIGN="right">362</TD><TD ALIGN="right"> </TD><TD ALIGN="right">6</TD><TD ALIGN="right">=VLOOKUP(E6,$A$1:$C$8,2,0)</TD><TD ALIGN="right">=VLOOKUP(E6,$A$1:$C$8,3,0)</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
7</CENTER></TD><TD ALIGN="right">=RANK(C7,$C$1:$C$8,0)</TD><TD ALIGN="right">Team Black</TD><TD ALIGN="right">222</TD><TD ALIGN="right"> </TD><TD ALIGN="right">7</TD><TD ALIGN="right">=VLOOKUP(E7,$A$1:$C$8,2,0)</TD><TD ALIGN="right">=VLOOKUP(E7,$A$1:$C$8,3,0)</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
8</CENTER></TD><TD ALIGN="right">=RANK(C8,$C$1:$C$8,0)</TD><TD ALIGN="right">Team Purple</TD><TD ALIGN="right">226</TD><TD ALIGN="right"> </TD><TD ALIGN="right">8</TD><TD ALIGN="right">=VLOOKUP(E8,$A$1:$C$8,2,0)</TD><TD ALIGN="right">=VLOOKUP(E8,$A$1:$C$8,3,0)</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
9</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right">(linked from their total)</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
10</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
11</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
12</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
13</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
14</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
15</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
16</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
17</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
18</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
19</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
20</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR></TABLE>
which'll look something like this :<TABLE BORDER="1" WIDTH="100%" BGCOLOR="white"><TR BGCOLOR="gray"><TD></TD><TD><CENTER>
A</CENTER></TD><TD><CENTER>
B</CENTER></TD><TD><CENTER>
C</CENTER></TD><TD><CENTER>
D</CENTER></TD><TD><CENTER>
E</CENTER></TD><TD><CENTER>
F</CENTER></TD><TD><CENTER>
G</CENTER></TD><TD><CENTER>
H</CENTER></TD><TD><CENTER>
I</CENTER></TD><TD><CENTER>
J</CENTER></TD></TR><TR><TD BGCOLOR="gray"><CENTER>
1</CENTER></TD><TD ALIGN="right">6</TD><TD ALIGN="right">Team Blue</TD><TD ALIGN="right">255</TD><TD ALIGN="right"> </TD><TD ALIGN="right">1</TD><TD ALIGN="right">Team Brown</TD><TD ALIGN="right">812</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
2</CENTER></TD><TD ALIGN="right">5</TD><TD ALIGN="right">Team Red</TD><TD ALIGN="right">326</TD><TD ALIGN="right"> </TD><TD ALIGN="right">2</TD><TD ALIGN="right">Team Green</TD><TD ALIGN="right">612</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
3</CENTER></TD><TD ALIGN="right">2</TD><TD ALIGN="right">Team Green</TD><TD ALIGN="right">612</TD><TD ALIGN="right"> </TD><TD ALIGN="right">3</TD><TD ALIGN="right">Team Yellow</TD><TD ALIGN="right">554</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
4</CENTER></TD><TD ALIGN="right">3</TD><TD ALIGN="right">Team Yellow</TD><TD ALIGN="right">554</TD><TD ALIGN="right"> </TD><TD ALIGN="right">4</TD><TD ALIGN="right">Team Orange</TD><TD ALIGN="right">362</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
5</CENTER></TD><TD ALIGN="right">1</TD><TD ALIGN="right">Team Brown</TD><TD ALIGN="right">812</TD><TD ALIGN="right"> </TD><TD ALIGN="right">5</TD><TD ALIGN="right">Team Red</TD><TD ALIGN="right">326</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
6</CENTER></TD><TD ALIGN="right">4</TD><TD ALIGN="right">Team Orange</TD><TD ALIGN="right">362</TD><TD ALIGN="right"> </TD><TD ALIGN="right">6</TD><TD ALIGN="right">Team Blue</TD><TD ALIGN="right">255</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
7</CENTER></TD><TD ALIGN="right">8</TD><TD ALIGN="right">Team Black</TD><TD ALIGN="right">222</TD><TD ALIGN="right"> </TD><TD ALIGN="right">7</TD><TD ALIGN="right">Team Purple</TD><TD ALIGN="right">226</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
8</CENTER></TD><TD ALIGN="right">7</TD><TD ALIGN="right">Team Purple</TD><TD ALIGN="right">226</TD><TD ALIGN="right"> </TD><TD ALIGN="right">8</TD><TD ALIGN="right">Team Black</TD><TD ALIGN="right">222</TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
9</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
10</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
11</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
12</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
13</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
14</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
15</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
16</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
17</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
18</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
19</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR><TR><TD BGCOLOR="gray"><CENTER>
20</CENTER></TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD><TD ALIGN="right"> </TD></TR></TABLE>
_________________
Hope this helps,
Chris
This message was edited by Chris Davison on 2002-04-26 22:08