Pick3 Excel Help

Reply #6

Cash2000 — Thu, 03 May 2018 02:02:03 GMT

hi my name is cash2000 I am working with the samethimg maybe we can help each other.

Reply #5

JSPL — Mon, 30 Apr 2018 10:24:24 GMT

Thanks for sharing, AlanB.

Reply #4

AllenB — Sun, 29 Apr 2018 03:03:30 GMT

Reply #3

phileight — Sun, 29 Apr 2018 00:44:47 GMT

ok you have a formula or formulas to convert your single cell picks to 3 cells and to compare this to your drawn data file. what info do you want from this?

example last box hit was 546 draws ago

last straight hit was 1478 draws ago

total matches last 5000 games 15

show me a list of all hits and skips

etc

whoever writes this for you has to know what you want. otherwise its a waste of time and effort

Reply #2

JSPL — Sat, 28 Apr 2018 20:39:26 GMT

Hi, thanks for the reply.

I should have been more specific in my post. A formula would be great.

Thanks,

Reply #1

AllenB — Sat, 28 Apr 2018 20:00:25 GMT

Questions

What Do You want to check?

What are you looking for? Formulas? an excel file

Pick3 Excel Help

JSPL — Sat, 28 Apr 2018 17:16:12 GMT

Hi,

I've been reading some of your posts for a while now, impressed with what I've seen here. I hope to get some help with what is probably a very simple fix for some of you excel junkies.

I have a history file of pick 3 numbers in columns A, B, C. I need to check them against my picks that are in one cell. I know there s going to be some fancy parsing here and I need them to check (obviously) in any order; 123, 312, 112, 333, etc.

Any ideas would be greatly appreciated.

Thanks... [ More ]