hi again teach.

we have a 10 team league so each week we have five games between two teams

each week is on it's on worksheet

giving me 18 worksheets

on the 19th sheet i have standings page

which i calculate the winning % of each team so that i know who is in 1st 2nd....

i do this by taking the avg of the winning and losing by the total amount of games and then sort the table

kind of like any standings results for any sport in any newspaper

team# 1 is team with best %

so i calculate for each team their wins and losses

i do this by adding 18 if's together

if boston score is greater than nyy score in week one then they get one if not 0 in the wins column

then i do the inverse for losses, with of boston is less than nyy in week one then 1 if not then 0

so i would end up with 1win 0 loss for bos in week one

so far what i do is when i have the schedule for all the weeks entered i go and manually do this,

so boston plays nyy week 1 then boston play seattle week 2, so on so forth. and i add them all to gether to give me the results of all the wins and all the losses. for each team

does this make more sense?

what i was trying to see is if there is a way to use a formula to find boston in each week and bring me back the results in each week without telling it what cell it's in, i have my sheets setup the same for all the 18 weeks and i know that from "boston game results" which is their score. that the score appears 12 columns after. and the team it goes against is either under or above it depending on who it is against, all sorted alphabetically. so when i play anaheim by team, boston, is below it when i play seattle it is above.

let me know if this helps at all

or if it just cinfused you even more

thanks

taz

p.s. i still can't use the pictue html maker as my work server does not allow downloads, server blocks me, friggin crap. lol