How To Analyse Tennis Points Data

[captainbang]

I have collected some tennis points data for 2020 and wanted to anlyse this data looking at certain scores but havent for the life of me any idea on how to do this and hoping someone here would know an excel formula. Im sure its probably quite easy but after days and days asking google i havent been able to find what im looking for.

For example lets look at the age old strategy of 15-40. If I have all the scoring seqeunces of a match how can i find out using excel [or any other application] how many times the score was 15-40 that went to 40-40?

I did this using conditional formating were each score in my query would be highlighted a colour and works fine but when you look at a years data i am just overwhelmed because id have to count the instances manually

Here is an example of the data if i was looking at 15-40 and the score goes to deuce.

[0-0*] [15-0*] [30-0*] [30-15*] [40-15*] [40-30*] [40-40*]

Any help on this would be great as I'm running out of words to type into google

[Atho55]

Try this =IF(AND(x="15-40",y="30-40",z="40-40"),1,0)

This will return a 1 if those 3 conditions are met with x,y,z being your cell references.

Otherwise pop a block of the data on here so we can have a look

[captainbang]

Try this =IF(AND(x="15-40",y="30-40",z="40-40"),1,0)

This will return a 1 if those 3 conditions are met with x,y,z being your cell references.

Otherwise pop a block of the data on here so we can have a look

Thanks Atho, I'll give this a try.

Maybe I should have included the data in my first post. I have attached a sample 100 rows of data

[spreadbetting]

Why not simply count the number of times the sequence 15-40 ? ? 40-40 occurs, should be able to do it with a bit of regex /15-40.*?40-40/

[Trading96]

I would suggest finding a better way to display the data, maybe for this purpose putting all the points for each game in it's own cell would be best.

Then do a countif formula.

[vinny2cool]

Here you go. I made an excel with the formulas you need!

I am very new to betfair and am also looking at tennis.
I have no clue how to go about collecting data like you have. Can you give me some pointers on how to go about collecting data like this?
Thanks!