i think this will do what you want. not sure if its the best way but i tested and it works.....it doesnt copy down correctly so youll have to manually edit g6 -g10 for g6 just change the A5:A10's to B5:B10 and g7 is C5:C10 and so on to the end
hello.. i was thinking about this... and for curiousitys sake id sure like to have a loop run just for fun to see how many times the numbers need to refresh before you get all 6 of your picks to match on any one of the 6 tickets. can anyone help with this?
are you running some sort of lottery and trying to get a lottery checker, this can be done with array formulas
i do the same thing at work, i have everybodys number stored in a spreadsheet and then just enter the weekly numbers that come out, all numbers that have been drawn highlight using conditional formatting, if you can wait til tommorow i can email you a blank copy of my file, the file i use also incorporates more than one weeks numbers if you need it to cant quite rememer the formula i used
shippey that sounds good. id like to have a look at your sheet. but still im looking for help with a loop. just to satisfy my curiousity on how many times the code would need to refresh before you get all 6 numbers to match. or basically about how many tickets youd need to buy
not that me or most ppl would or even could buy that many. still i am just curious. the loop is probably an easy thing ofr one of the guru guys here ...
set you sheet out as in my example then in your first row of numbers my example B2 goto conditional formatting and select fomula is and enter the above formula. choose formats as required
then click ok, right click on the first number and click copy, highlight the rest of your numbers to be checked and right click, Paste Special >> FORMATS this will copy the formats to the rest of your cells,
now enter numbers in the draws boxes and number drawn will highlight
the B2 in my formula is the first cell of my numbers to be checked
the =$B$12:$G$16 is the range of the draw1 to draw5 cells adjust as required but remember to use absolute refrences ($) in this part