I run a racing league and generate results tables for it. There are individual worksheets for each race where results are entered, then a separate Driver Championship worksheet is automatically generated from it, and likewise for a Team Championship worksheet.
I am having a problem with the Team Championship worksheet. I use the following formula to extract the points a driver receives from each race from the individual race worksheets:
(Sorry guys, can't get the Formula to save in the post in full as CODE tags or any other way - keeps cutting off the end of the formula and removing the close code tag. <aus!$f$20),"dns","-"))[ code]
<aus!$f$20),"dns","-"))[ code]
<aus!$f$20),"dns","-")) [="" code]
<aus!$f$20),"dns","-"))
<aus!$f$20),"dns","-"))
<aus!$f$20),"dns","-"))[ quote]
<aus!$f$20),"dns","-"))
<aus!$f$20),"dns","-"))
<aus!$f$20),"dns","-"))
Here it is as an image)
<aus!$f$20),"dns","-"))
This works absolutely perfectly, with one rare exception. A driver can, on a rare occasion, driver for more than one team. What the formula is doing with such instances, is it is taking his race results, and applying them to both teams. For instance, if he drove for Team A in Race 1, and drove for Team B in Race 2, his results from Race 1 are applied to Team A and to Team B, and likewise, his results for Race 2 are applied to Team A and to Team B.
Here's a look at the worksheets to complete the picture:
Constructors Championship Worksheet
Race Worksheet (This one is AUS - there are 19 of these)
Drivers Worksheet
You can see with the drivers named Disc0Potat0 & JDigital28, their results for all races showing up for both teams they have driven for. With JDigital28 for instance, it should show that he had a DSQ at TUR with McLaren, and had 8 points at ESP with Ferrari.
Would greatly appreciate any help with this.</aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))></aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))[></aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))></aus!$f$20),"dns","-"))[></aus!$f$20),"dns","-"))[>
I am having a problem with the Team Championship worksheet. I use the following formula to extract the points a driver receives from each race from the individual race worksheets:
(Sorry guys, can't get the Formula to save in the post in full as CODE tags or any other way - keeps cutting off the end of the formula and removing the close code tag. <aus!$f$20),"dns","-"))[ code]
<aus!$f$20),"dns","-"))[ code]
<aus!$f$20),"dns","-")) [="" code]
<aus!$f$20),"dns","-"))
<aus!$f$20),"dns","-"))
<aus!$f$20),"dns","-"))[ quote]
<aus!$f$20),"dns","-"))
<aus!$f$20),"dns","-"))
<aus!$f$20),"dns","-"))
Here it is as an image)
<aus!$f$20),"dns","-"))
This works absolutely perfectly, with one rare exception. A driver can, on a rare occasion, driver for more than one team. What the formula is doing with such instances, is it is taking his race results, and applying them to both teams. For instance, if he drove for Team A in Race 1, and drove for Team B in Race 2, his results from Race 1 are applied to Team A and to Team B, and likewise, his results for Race 2 are applied to Team A and to Team B.
Here's a look at the worksheets to complete the picture:
Constructors Championship Worksheet
Race Worksheet (This one is AUS - there are 19 of these)
Drivers Worksheet
You can see with the drivers named Disc0Potat0 & JDigital28, their results for all races showing up for both teams they have driven for. With JDigital28 for instance, it should show that he had a DSQ at TUR with McLaren, and had 8 points at ESP with Ferrari.
Would greatly appreciate any help with this.</aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))></aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))[></aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))
</aus!$f$20),"dns","-"))></aus!$f$20),"dns","-"))[></aus!$f$20),"dns","-"))[>
Last edited: