What my goal for the formula to do is:
Sort teams by a score into three tiers.
each team has a C.Score, each score is between 1 and -2. the score determines what tier the team is in, with the frist tier being teams with score above 0, and the second tier being teams with scores between -1 and 0, and third tier being teams with scores between -1 and -2. once the teams are seperated into tiers, they need to be ranked, highest score to lowest within that tier.
how my spreadsheet is set up, is the league standings on sheet 1,
the team and current score(calculated from standings on sheet1) on sheet 2, and then the three tiers on sheet 3, to be determined by the scores on sheet 2.
I have successfully gotten the scores to calculate across sheets, but i can not find a formula that would suit my need for the teams to be ranked into their teirs.
I would soo appreciate any help on this, im anxious to finish this project, i will be testing the sytem for this season and playoff season to determine its effectiveness. If it is proven effective, i will be presenting it to the league to replace the current point system! They are looking forward to seeing my point system work.
The spreadsheets are attached. file name: NHL standings
Thanks for your interest,