Search

My Pick-4 Work Out 1 2 3 1Reply
emilyg... here's what I have figured for pick 3, I still need to mod it for pick 4...(Thanks to ERAE for the help inspiration, formula sharing is cool! hope you like my mods)=IF(S2=(($D3*100)+($E3*10)+$F3), S ,IF(S2=(($D3*100)+($F3*10)+$E3), B ,IF(S2=(($F3*100)+($E3*10)+$D3), B ,IF(S2=(($F3*100)+($D3*10)+$E3), B ,IF(S2=(($E3*100)+($D3*10)+$F3), B ,IF(S2=(($E3*100)+($F3*10)+$D3), B , ))))))Assumes S2 contains the first result of your workdownAssumes D3, E3 and F3 contain the next day's result
Dec 22, 2003, 10:26 pm - hypersoniq - Pick 4 Forum

My Pick-4 Work Out 1 2 3 1Reply
I redid the sheet, leaving one cell that I can plug any number into and automatically perform the rundowns and count straight and box hits, I fixed one or two errors with the formula and I apologize to anyone who tried to copy the formula and was greeted with the formula is too large error. The trick is to break it down into four subsections... the first will check for straight and 5 box combos, and the other 3 each check for 6 box combos. A simple countif at the end for S's and B's will tell
Dec 26, 2003, 3:16 pm - hypersoniq - Pick 4 Forum