HI Chaps nice site you have here
I just wondered if you could help me with little problem i have?
I created a automated football league with 5 teams in it that updated the team positions
(moved them up and down)as the new data was added in the secondary table and i used this type of formula in the secondary table on a rank system to rank positions according to points/wins/goal/difference/ect this also places the appropriate teams in alphabetical order in case the teams have equal stats
=RANK(O4,$O$4:$O$13)+RANK(G4,$G$4:$G$13)/10+RANK(N4,$N$4:$N$13)/100+RANK(F4,$F$4:$F$13)/1000+RANK(E4,$E$4:$E$13)/10000+1/100000
and this formula in the primary table that updates its self
=SMALL($A$4:$A$13,1) in the ranking
and this type of formula to transfer the data to the appropriate destination from the secondary table to the self adjusting primary table
ie points/ goals/ect
=INDEX($A$4:$O$13,MATCH($A22,$A$4:$A$13,0),4)
my question is i now want to extend my table to 24 teams so can i still use this ranking system as the range of 10/10000 only seems to let me use 10 teams( not tested yet)not sure how it works
any ideas or help would be appreciated
thx
Bookmarks