Excel help: a formula or macro to count digit followers

Reply #14

alchemist7 — Fri, 18 Mar 2016 16:55:06 GMT

Hi to all,

Thanks AllenB for another way to solve my problem. I may use it in my original work book if it can't handle all of the macros that are already in it. I didn't know how to start either way Macro or cell formula. I was thinking along your line but just couldn't figure a starting point. So thanks again.

Phileight thanks for the revision, I wasn't complaining or anything I just needed a starting point as I stated above I saw how you wrote so I adapted it for a pick 4 draw. I'm not g... [ More ]

Reply #13

phileight — Fri, 18 Mar 2016 11:31:04 GMT

That's my excuse. seem to use it more every day. 47 was so loooong ago. the revised version fixed having to add 6. It's just my habit I like to leave a few lines at top for future use. with minor changes to the macro the data file could easily start on line 1.

It could be incorporated into an existing spreadsheet. it could copy and paste an existing file from an open spreadsheet. it could select the midday or evening file etc. none of these things were in Alchemist7's request.

if there i... [ More ]

Reply #12

CARBOB — Fri, 18 Mar 2016 09:09:24 GMT

I missed that, getting old, thanks.

Reply #11

AllenB — Thu, 17 Mar 2016 23:51:48 GMT

So run the data, summarize it, erase the columns and just run the combined number for a new game and update your history. That is where you use the macro. Trying to do all of this with a macro is way beyond me. You could record a macro for the update.

Reply #10

phileight — Thu, 17 Mar 2016 23:06:00 GMT

That would work. I am partial to macro's, they are usually faster, and easier for me to set up. Long lines of formulas are a pain, having to store intermediate results tend to clutter the display. I never try to hide or protect the code, so if anyone wants to modify it they can.

Reply #9

AllenB — Thu, 17 Mar 2016 22:04:54 GMT

Here is what I would do. Say your data is set up with the Game or date in column A Column B is the first number drawn and the one we will check. Columns C and D are the other 2 drawn numbers. In column E in Row 2 enter this formula =B2 B3. that will give the new number combined with the previous number. Now all you have to do is count the Sequences that match the pattern you want. So to find how many times 0 comes after 4 write this formula =countif(E1:E200, 04 ).

This setup would be for 200... [ More ]

Reply #8

phileight — Thu, 17 Mar 2016 21:40:20 GMT

I had seen that while I was working on it and had intended to make that correction, just forgot. any way the corrected version is at he same link.

Reply #7

SergeM — Thu, 17 Mar 2016 16:34:16 GMT

Easier asked for than done

Reply #6

alchemist7 — Thu, 17 Mar 2016 16:05:52 GMT

Hi Carbob,

You would change the number under #games. Just keep in mind that the number refers to the row not the actual number of games. If you have a particular number of games in mind then you would have to add that number to 6.

Reply #5

CARBOB — Thu, 17 Mar 2016 12:15:28 GMT

How do you adjust the game count

Reply #4

alchemist7 — Thu, 17 Mar 2016 12:00:17 GMT

Hi Serge,

Its for SC. Phileight gave me what I was looking for. I like that I could change the number of draws that I want to analyze. That would be great if you include that state on your site and thanks for asking.

Reply #3

SergeM — Wed, 16 Mar 2016 19:08:00 GMT

Which state? I have NY and CA at the moment. I am working on CA, next on BE.

Reply #2

alchemist7 — Mon, 14 Mar 2016 17:48:51 GMT

Hello Phileight,

This is what i was looking for! Thanks for you help!

Achemist

Reply #1

phileight — Mon, 14 Mar 2016 16:30:21 GMT

see if this is what you wanted. copy and paste your database if it suits you. you can adjust how many games to include currently set to 500

https://www.dropbox.com/s/pxxenycr7rjw9xh/follower%20freq.xlsm?dl=0

Excel help: a formula or macro to count digit followers

alchemist7 — Mon, 14 Mar 2016 14:17:16 GMT

I'm looking for away to count the frequency of 0,1,2,3....etc that follows a particular number such as 4 with in a column.

Ex:

col 1 the number count for the digit 6; digits 7,4,2 all have 1 and every other has 0.

4 9 2 8

9 3 1 10

9 10 1 10

2 5 1 1

6 9 6 8

7 1 3 6

6 5 5 6

4 2 7 8

6 7 3 2

2 9 3 8

I did a search found a few members have something close to what i'm looking for but no formula for excel. Here is the best i... [ More ]