Forum Discussion
excel lottery
what i wanted it to do is number the skips 1234 then skipmathetes hits then count and number the skips.
- Steve305Jan 27, 2024Copper Contributor
Sure! To create a solution that tracks how often a number hits and the skips before it hits again, you'll need a spreadsheet setup that involves a few steps. Here's a simple approach to achieve this:
List Your Numbers: First, you'll need a column where you list the numbers you're tracking. Let's say this is Column A.
Track Hits: In Column B, you'll track each occurrence of the number. You can mark a hit with a 1 or any identifier you choose.
Calculate Skips: In Column C, you'll calculate the number of skips before the number hits again.
Here's a basic formula you can use in Excel or Google Sheets. Assuming you start from row 2:
In Cell B2, you could input =IF(A2=YourNumber,1,0). Replace YourNumber with the specific number you're tracking. This formula checks if the cell in Column A is the number you're tracking and marks it as a hit (1) if it is.
In Cell C2, input =IF(B2=1,0,C1+1). This formula checks if there's a hit in Column B. If there is, it resets the skip count to 0. If there isn't, it adds 1 to the previous skip count.
Copy these formulas down the respective columns for as many rows as you have data.
This setup will give you a simple way to see how often a number hits and the number of skips between hits. Adjust the formulas as needed based on your specific requirements and data structure. Must see I have used table for https://mobdroapkz.com/lunchtime-2-hot-numbers-for-today-2-pair-predictions/, https://mobdroapkz.com/