Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
lotto excel formula
Name: sonofsnap Date: June 29, 2003 at 17:05:51 Pacific OS: me CPU/Ram: 1gig 384mb
Comment:
Last month I posted a question about making a formula to check lotto numbers. A lotto bingo where the numbers are accumulative until someone matches all their numbers. Anyway here is the formula to do this, just in case anybody needs it or something similar in the future. =IF(AND(D2="x",E2="x",F2="x",G2="x",H2="x",I2="x"),"****WINNER****","NO") Now to use it, all you do is highlite cells "D" through "I" and press "Edit", "Replace" in the "find what" box (enter lotto number) In the "Replace box put the letter "X" now click replace all. Do this for each looto number until someone matches all their numbers. * note: the letter "o" must precede all single digits i.e. "o7". Screenshot
Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. Currently I put in data for each column and it is ...
Summary: For no apparent reason I have encountered problems with excel formulas. Instead of dragging formulas across columns, my speadsheets are copying information only. Also, summed columns of figures are no...
Summary: Hi, Hate to bother every1, just have a quick question regarding a excel formula. Im using a lot of =sum formulas, i was just wondering in my total figures, is there any chance i can have the display v...
