Question about Excel

Reply #2

winsumloosesum — Fri, 12 Apr 2019 00:32:04 GMT

This is a simple Excel spreadsheet (version 2010 Excel) inside the zip file:

https://my.pcloud.com/publink/show?code=XZ1S2E7Z6voyi9iHkbJhCEKKN3ciwmdvFPRk

1 Open Pick4Dump

2 In cell column D (going down) you would copy and paste your 30 Pick 4 games. You can enter more but will need to drag the formulas down in cell columns F, H, and J to match the total amount of Pick 4 sets you entered in cell column D

3 For example. In cell column M I entered a formula to randomly select a Pick 4 s... [ More ]

Reply #1

cottoneyedjoe — Wed, 10 Apr 2019 20:48:35 GMT

Are the digits of each number in separate columns? If so, here is a mathematical solution to identifying numbers that are equivalent as box sets.

Say the digits are in columns A, B, C, and D. Create four functions in four new columns, say W, X, Y, and Z.

Column W is the sum of the digits, i.e., A+B+C+D

Column X is the sum of each digit's square, i.e., A*A + B*B + C*C + D*D

Column Y is the largest digit, i.e., MAX(A,B,C,D)

Column Z is the smallest digit, i.e., MIN(A,B,C,D)

The... [ More ]

Question about Excel

ftdsn244 — Wed, 10 Apr 2019 19:02:45 GMT

Hello. i was wondering if there was a way to dump numbers in an excel or other program and it find matches even if different order (1234,3421)

For instance if I'm looking up a couple different users #'s for the day and they each have 30 #s they like. Instead of me looking through 90 numbers total to see if they all agree on a certain number, can i just dump all 3 of the users picks and the excel or other program just find the matches for me?

Make sense?

Example if they all have... [ More ]