I like meny people have done quite a few lines for the lottery this week, i have put them in a spread sheet and would like to type the winning numbers into my sheet and then have it query my numbers and either highlight the matches or even better show the number of matches in a new column.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Creating a lottery Checker
- Thread starter danhole
- Start date
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Upvote
0
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
Assuming the winning numbers are in A1:G1
and your selections in A3:F3, A4:F4 etc.
then you could select your range of selections and use this formula in conditional formatting
=MATCH(A3,$A$1:$F$1,0)
to highlight all matches
for a total of matches on each row, adding to Parsnip's suggestion, this formula can be use in H3 copied down column
=SUMPRODUCT(1-ISNA(MATCH(A3:F3,A$1:G$1,0)))
and your selections in A3:F3, A4:F4 etc.
then you could select your range of selections and use this formula in conditional formatting
=MATCH(A3,$A$1:$F$1,0)
to highlight all matches
for a total of matches on each row, adding to Parsnip's suggestion, this formula can be use in H3 copied down column
=SUMPRODUCT(1-ISNA(MATCH(A3:F3,A$1:G$1,0)))
Upvote
0
