| Posted: September 19, 2009, 3:51 pm - IP Logged | |
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.
