Forum Discussion
Solved
Roulette Tracking
I have a spreadsheet where I count the results of spins on a Roulette wheel. How can I track the number of spins since the last time a specific result occurred? For example, how many spins has it bee...
=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.