Excel Help!

Reply #6

frank141 — Thu, 14 Feb 2019 04:26:39 GMT

Thanks CARBOB, will check this method and post.

Reply #5

CARBOB — Wed, 13 Feb 2019 14:31:21 GMT

Example of followers for Hybirds. Top are the hits, bottom are the skips.

Hits formula to enter Ctrl-Shift-Enter =IFERROR(1/(1/(SUMPRODUCT(--(DRAWS!$L$21:$L$7124=$DM2),(--(DRAWS!$L$22:$L$7125=DN$1))))), )

Skips Formula to enter same procedure =IFERROR(MATCH(1,(DRAWS!$L$21:$L$7124=$DM7)*(DRAWS!$L$22:$L$7125=DN$6),0)-1, )

P1 0 1 2 3 P2 0 1 2 3 P3 0 1 2 3

0 422 476 452 412 0 445 455 476 388 0 460 458 436 464

1 453 517 491 436 1 438 472 491 425 1 469 447 446 463

Reply #4

frank141 — Wed, 13 Feb 2019 10:22:12 GMT

Thanks AllenB,

But could you upload it again as apparently the file doesn't exist. Will be much more prompt in my reply this time.

Reply #3

AllenB — Wed, 06 Feb 2019 22:04:38 GMT

https://1drv.ms/x/s!As5vGPYDVqVmiSUZtTaiGzljyDib

Try This and let me know if you want anything changed or added.

Allen

Reply #2

frank141 — Wed, 06 Feb 2019 17:38:01 GMT

Thanks AllenB,

The most recent draws are on top The key digit is in the first column only. I am more interested in the column that 6 occurs (in this case the first column), i want to find what number(s) occurs-follows after the number 6 is played in column 1. The count frequency i can easily do o my own

Reply #1

AllenB — Tue, 05 Feb 2019 02:08:47 GMT

a). Find all the numbers that occurs after the number 6 occurs in the next row above.

Are You arranging the Draws with Ascending Order? Just Checking, I usually Set the most current Draw at the Top.

Are You Setting the Key Digit 6 in the First Column or are you Applying the Key 6 to all 4 Columns?

b). Count the frequency such number occurs after 6.

There are 2 Ways to do the Count. Total including Doubles or Games containing the Digit. Frequency generally refers to per Game, so I ass... [ More ]

Excel Help!

frank141 — Mon, 04 Feb 2019 15:25:51 GMT

Hello everybody, hope you are all having a great day. I am wondering if someone can be kind enough to help me with by problem.

I would appreciate an excel formula/macro/vba. etc. that can extract all the numbers that follow a particular number. In the example here, i have highlighted the number 6 and i would like to:

a). Find all the numbers that occurs after the number 6 occurs in the next row above

b). Count the frequency such number occurs after 6.

Gladly appreciate any help given... [ More ]