I am stumped and need help. I want to create an excel sheet where I will input the results of each roll of the dice while I play online Craps, I want a formula that will show me how many rolls occur until a 7 comes up, not on which roll it pops up but how many rolls BEFORE it pops up. I can make it count until the first 7 but I need it to account for multiple 7's down the list as I input and cannot figure it out. Any ideas??
Are you still using Excel 2010?
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks