Enter this formula in cell H7 =IF($H$6=$C7,1,IF($H$6=$D7,1,IF($H$6=$E7,1,IF($H$6=$F7,1,IF($H$6=$G7,1,".")))))
Enter this formula in Cell I7 =IF($I$6=$C7,1,IF($I$6=$D7,1,IF($I$6=$E7,1,IF($I$6=$F7,1,IF($I$6=$G7,1,".")))))
Enter this formula in Cell J7 . =IF($J$6=$C7,1,IF($J$6=$D7,1,IF($J$6=$E7,1,IF($J$6=$F7,1,IF($J$6=$G7,1,".")))))
Enter this formula in Cell K7 =IF($K$6=$C7,1,IF($K$6=$D7,1,IF($K$6=$E7,1,IF($K$6=$F7,1,IF($K$6=$G7,1,".")))))
Enter this formula in cell L7 =IF($L$6=$C7,1,IF($L$6=$D7,1,IF($L$6=$E7,1,IF($L$6=$F7,1,IF($L$6=$G7,1,".")))))
Enter this formula in Cell M7 =COUNTIF(H7:L7,1)
Enter this formula in Cell N7 =VLOOKUP(M7,$Q$4:$R$7,2)
copy this formula’s down as many cells as you want.
Copy this or make it in your Excel sheet in cell B4
|
Cash 5
|
H5
|
I5
|
J5
|
K5
|
L5
|
M5
|
N5
|
|
Enter winning numbers here
|
|
1st
|
2nd
|
3rd
|
4th
|
5th
|
|
Cell C6
|
1st
|
2nd
|
3rd
|
4th
|
5th
|
13
|
23
|
26
|
25
|
38
|
# U Hit
|
U Won
|
|
|
1
|
7
|
16
|
25
|
38
|
.
|
.
|
.
|
1
|
1
|
2
|
$1.00
|
|
Numbers Here
|
13
|
23
|
26
|
37
|
39
|
1
|
1
|
1
|
.
|
.
|
3
|
$3.00
|
|
|
13
|
23
|
26
|
25
|
38
|
1
|
1
|
1
|
1
|
1
|
5
|
JP
|
Copy or make this in cell Q3 Copy formula’s down as many cell as you wish
|
Match
|
Winning
|
|
2
|
$1
|
|
3
|
$3
|
|
4
|
$351
|
|
5
|
JP
|
The winning amounts change each day as the JP gets rolled over each day.
