https://imgur.com/r5isISk
hi everyone
the link there takes you to a screenshot of a spreadsheet I have operated for several years to record results of a weekly indoor football game with friends with teams chosen at random. hopefully its reasonably self explanatory how I have set it up as it is quite basic. I was looking for help with a couple of things though...
firstly does anyone know of a formula I could use to find out statistics for 2 particular players together. for example I would like to see the results for when "Coco" and "Penzo" are on the same team. Currently the only way the sheet would know they are on the same team is because I have manually entered "win" "lose" or "draw" in the particular weeks cell.
furthermore, does anyone have ideas for completely revamping it, so its run almost database style, whereby each week I fill in something to show teams and result and it auto-fills all sorts of statistics. I am open to all sorts of suggestions.
thanks!
hi everyone
the link there takes you to a screenshot of a spreadsheet I have operated for several years to record results of a weekly indoor football game with friends with teams chosen at random. hopefully its reasonably self explanatory how I have set it up as it is quite basic. I was looking for help with a couple of things though...
firstly does anyone know of a formula I could use to find out statistics for 2 particular players together. for example I would like to see the results for when "Coco" and "Penzo" are on the same team. Currently the only way the sheet would know they are on the same team is because I have manually entered "win" "lose" or "draw" in the particular weeks cell.
furthermore, does anyone have ideas for completely revamping it, so its run almost database style, whereby each week I fill in something to show teams and result and it auto-fills all sorts of statistics. I am open to all sorts of suggestions.
thanks!
