Forum Discussion
Roulette Tracking
You could help us help you by giving a bit of basic information on how you track the results in the first place. What sort of records do you have which could serve as the source information for answering the question you have?
Otherwise you're, in effect, asking us to do the whole process of designing the initial tracking system. And we might do something altogether different from how you approach this.
Thank you so much for your response! Below is a screenshot of my tracking sheet, I input the spin results in column N (next result to be input into row 24) and the rest of the sheet displays those results as they pertain to different bets/layouts on the roulette board. The top of the sheet is frozen (row 8 and above) and the data field runs downward for 500 results.
My goal is to have numbers in each of the column headings (columns O to AF in this example) that reflect the number of spin results since each occurred.
The top left obviously shows the layout of the numbers on a roulette board and I would like to replace those numbers with the information 'number of spins since last occurrence', example; instead of showing the number 7 (D6), I would like to display the number of spins since 7 was the result.
I appreciate your help!
=SMALL(IF(ISBLANK(N9:N10000),ROW(N9:N10000)-8),1)-LARGE(IF(N9:N10000=7,ROW(N9:N10000)-8),1)
You can apply this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
how can i get this excel sheet for my personal useBrian_MacLeod
