Pick3 and Pick4 Hit Checker?

Reply #3

LottoChica23 — Wed, 07 Jun 2006 20:37:52 GMT

Thanks folks...

I got a crude visual worksheet working. I used Countif and conditional formatting to see what is going on with the digits.

Reply #2

cps10 — Wed, 07 Jun 2006 19:15:04 GMT

I would suggest getting the numbers in Excel and doing a COUNTIF like SirMetro suggested.

Reply #1

SirMetro — Wed, 07 Jun 2006 19:13:32 GMT

If you setup a sheet where you list all your selections, input the formula to reduce the number to it's lowest BOX form (eg: 321 would become 123), then a quick visual scan will allow you to review your list quickly. If the list is huge, you can do a search (or countif() function) to hunt it down for you. That would be my thoughts.

Sir Metro

Pick3 and Pick4 Hit Checker?

LottoChica23 — Wed, 07 Jun 2006 18:46:41 GMT

Hi All,

With all of the testing that we do of various systems and programs, I was wondering if anyone knows of a program or spreadsheet that checks a field of number picks for a hit?

This would speed up testing if you don't have to sift through the picks to see where the hits are. If anyone can point me in the right direction I would greatly appreciate it.

Thanks