Hi all,
Needing some help with a online F1 racing league simulation table to create a constructors/team table.
I have the individual drivers standings side of it working perfectly but for the new season they have introduced teams and I don't have the excel knowledge how to make this.
I want it so excel, picks up the two drivers names (the two teammates) from the driver table and adds their two respective points together, regardless of where the drivers points 'cell' has moved to.
was going to make constructor table on seperate sheet but can make it on the same one as drivers table if easier.
Thank you so much in advance if anyone can help!
Needing some help with a online F1 racing league simulation table to create a constructors/team table.
I have the individual drivers standings side of it working perfectly but for the new season they have introduced teams and I don't have the excel knowledge how to make this.
I want it so excel, picks up the two drivers names (the two teammates) from the driver table and adds their two respective points together, regardless of where the drivers points 'cell' has moved to.
was going to make constructor table on seperate sheet but can make it on the same one as drivers table if easier.
Thank you so much in advance if anyone can help!