Welcome Guest
You last visited December 5, 2016, 1:37 pm
All times shown are
Eastern Time (GMT-5:00)

# Excel Formula for Pick 4

Topic closed. 21 replies. Last post 4 months ago by Tialuvslotto.

 Page 2 of 2
Zaperlopopotam
Belgium
Member #173932
March 26, 2016
952 Posts
Offline
 Posted: August 11, 2016, 4:38 pm - IP Logged

How to create a short circuit.

New Jersey
United States
Member #17843
June 28, 2005
49699 Posts
Offline
 Posted: August 11, 2016, 4:54 pm - IP Logged

How to create a short circuit.

https://www.lotterypost.com/help/178423

A mind once stretched by a new idea never returns to its original dimensions!

Zaperlopopotam
Belgium
Member #173932
March 26, 2016
952 Posts
Offline
 Posted: August 11, 2016, 7:51 pm - IP Logged

href

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: August 12, 2016, 6:28 am - IP Logged

Or shorter version:

=IFERROR(VLOOKUP(MAX(FREQUENCY(C1:F1,C1:F1)),{1,"NM";3,"T";4,"Q"},2,0), LOOKUP(SUM(IF(FREQUENCY(C1:F1,C1:F1)=2,1)),{1,"D";2,"DD"}))

Control-Shift-Enter

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5896 Posts
Offline
 Posted: August 12, 2016, 6:33 am - IP Logged

I don't see anything for a consecutive.

Texas
United States
Member #150797
December 31, 2013
815 Posts
Offline
 Posted: August 12, 2016, 7:04 am - IP Logged

Thanks for posting the link to the original thread, Raven.  I forgot to do that!

"There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

~Robert A. Heinlein

Texas
United States
Member #150797
December 31, 2013
815 Posts
Offline
 Posted: August 12, 2016, 7:08 am - IP Logged

I'm sure there's a shorter version than this:

=IF(SUMPRODUCT((\$C1:\$F1=\$C1)+(\$C1:\$F1=\$D1)+(\$C1:\$F1=\$E1)+(\$C1:\$F1=\$F1))=16,"Q",IF(SUMPRODUCT((\$C1:\$F1=\$C1)+(\$C1:\$F1=\$D1)+(\$C1:\$F1=\$E1)+(\$C1:\$F1=\$F1))=10,"T",IF(SUMPRODUCT((\$C1:\$F1=\$C1)+(\$C1:\$F1=\$D1)+(\$C1:\$F1=\$E1)+(\$C1:\$F1=\$F1))=8,"DD",IF(SUMPRODUCT((\$C1:\$F1=\$C1)+(\$C1:\$F1=\$D1)+(\$C1:\$F1=\$E1)+(\$C1:\$F1=\$F1))=6,"D","NM"))))

Example: Excel 2010

All 10,000 sets

https://1drv.ms/u/s!AifgvyqwTTMrg0dXbAgE5Tsge_xk

Thanks, Winsum! Again!  Appreciate the spreadsheet.

You are the Excelmeister!

"There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

~Robert A. Heinlein

 Page 2 of 2