Ok guys I got the following spreadsheet for a ping pong result table for best 2 of 3 match play
I got 'Form Responses'!D:D which has name for Player 1
I got 'Form Responses'!E:E which has name for player 2
I then 'Form Responses'!F:F Set 1 Stats Player 1
I then 'Form Responses'!G:G Set 1 Stats Player 2
I then 'Form Responses'!H:H Set 2 Stats Player 1
I then 'Form Responses'!I:I Set 2 Stats Player 2
I then 'Form Responses'!J:J Set 3 Stats Player 1 (Not always filled if set 1 and 2 is won by same player)
I then 'Form Responses'!K:K Set 3 Stats Player 2 (Not always filled if set 1 and 2 is won by same player)
On my next page I have column A2:A8 a list of player names
what I want to do is find out how many sets they play from Form Response
I tried to count the cells if they had value and then divide it by 2, but I cant seem to get that to work?
Please how could I do this
I am using google docs JUST FYI
Matt
Bookmarks