Thread
:
matching numbers
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
TomPl
external usenet poster
Posts: 342
matching numbers
Assume columns A,B,C,D,E,F,G,H
Assume rows 1 and 2
Put the fomula =count($A$1:$H$1,A2) in cell A3
Copy that formula to cells B3:H3
Then sum cells A3:H3 to get the total number of matches for your lottery pick.
Tom
Reply With Quote
TomPl
View Public Profile
Find all posts by TomPl