Help with lottery project plse

  • Thread starter Thread starter Silvabod
  • Start date Start date
S

Silvabod

Office 2003, with major limitation - Mono printer so no colour highlights.
And it's a weekly print that's needed, so participants can easily see their
situation.

Project is lottery variant. Choose 6 numbers, winner(s) are those whose 6
numbers "come up" over a period of weeks, with a "booby" for those who have
NO numbers drawn when its won.

Col A1 - A60 - name list
Range B1 - F60, their random choice of numbers between 1 and 49

Col I1 Drawdate 1, Col J - O the lottery draw numbers.
Col H2 Drawdate 2, Ditto Ditto, etc (about 8 weeks max)

Compare Data range B1 - F60 with data range J1 - O8, if a "match", change
cell format to BOLD (and perhaps font too)

In col G, check rows B-F - If all are BOLD format, type "WINNER" else ""
(alternatively, if all 6 match data in range J1-O8, type "WINNER"
In Col H, check range G1-G60 - If "WINNER", AND row contains NO Bold, type
"BOOBY PRIZE" (alternatively, IF range H1 - H60 includes "WINNER" and row
contains NO matches in data range J1 - O8, "BOOBY PRIZE"

I'm floundering - it's some years since I used Excel (97), and Excel 2003
seems to have lost the "button" facility within a spreadsheet (assign a
macro, click the button to run it)

Would appreciate some help with this project please? I was never an "expert"
anyway.
Silvabod
 
Usually we answer specific questions to help solve a problem. Projects are
what many of us do for a living.
 
Since I currently don't do anything for a living, I'm available for
projects!

If the OP wants to contact me at:

xl can help at comcast period net (remove can)

I'll be glad to do this!

Biff
 
Back
Top