Hi, me again!
I am attempting to do a spreadsheet to note peoples performance in my local pool team.
I though i could use 0 as a loss and 1 as a win.
Can i get a formula to recognise the name "darren" and how many instances of "0", how many instances of "1" and the percentage of losses to wins?
here is how i thought i would lay it out:
Singles:
Game 1 Darren 0 1
Game 2 Chris 1 0
Doubles:
Game 3
Darren 1 and Chris 1
Jamie 0 and Dave 0
obviously for doubles i would have to put 2 lots of results down...
any suggestions welcomed!
Thanks
I am attempting to do a spreadsheet to note peoples performance in my local pool team.
I though i could use 0 as a loss and 1 as a win.
Can i get a formula to recognise the name "darren" and how many instances of "0", how many instances of "1" and the percentage of losses to wins?
here is how i thought i would lay it out:
Singles:
Game 1 Darren 0 1
Game 2 Chris 1 0
Doubles:
Game 3
Darren 1 and Chris 1
Jamie 0 and Dave 0
obviously for doubles i would have to put 2 lots of results down...
any suggestions welcomed!
Thanks