skips

Hi, I'm looking to create an Excel sheet that can analyse previous lottery (5/47) draws . I want to make columns that can identify how many draws since numbers were last seen, average skips and when they are due again. Any help with a formula would be very gratefully appreciated. Thanks Rob

https://app.box.com/s/f3iwju014t1h01kphthqslln68zo1scq The top box tracks the number of times a value has followed another value.The values in the lower box are the skips. Skips are the number of draws since it was last hit. I would like to add another box to track the maximum skip in all draws.

Hello all, I am trying to copy formula that skips a column from another sheet. So for example, B2 = sheet1!C2/sheet1!B2 C2 = sheet1!E2/sheet1!D2 D2 = sheet1!G2/sheet1!F2 Is there any easy way to copy this formula to the right? Thank you, BC

I have a long macro that works great every time I run it except if I try to save at the end. If I put ActiveWorkbook.Save at the end it skips the code in front of it and just saves and does nothing else. What would cause this? I'm using the latest Excel and windows 10.

Hello, I have the following code to convert Word documents saved in a specific folder to PDFs, but when the code is ran, it skips over the first file in the folder and doesn't convert it. If i run the code a SECOND time, it will convert it. Any ideas why it skips over? Sub DOC_PDF()...

<colgroup><col></colgroup><tbody> =MATCH(BC$5,INDIRECT("A"&SUM(BB$15:BB15)+1&":$A$10000"),0) This formula works when finding skips between numbers. Is there a formula for finding skips between letters? </tbody>

So I'm trying to use a vlookup to check a table of a few values, and only print the numbers if the value is more than zero. Column A returns the value in Column C IF Column D is at least 1 or higher. If Column D is zero, Column A skips the Column C value. I have approx 3000 rows to validate...