Hello,
So i'm building a spreadsheet to help track my team's darts ladder and I ran into a small problem.
I'm recording the matches in a simple table and using that table to generate a host of others. The way I've built it depends upon the matches being laid out as they are inthe attached sheet.
However, I am struggling to write a formula to calculate:
1. the current win streak of each player - the number of wins in a row they currently have.
2. the longest win streak the player has ever achieved - teh highest number of wins in a row they have ever had.
Its totally beyond me! I've attached a sheet which shows the basic layout i'm after and wonder if anyone can do something suitably genius-like to it?
Many thanks for your time in reading this and many more if you have a solution!
Thanks,
Andrew.Attachment 446504Attachment 446504
Bookmarks