|Posted: January 14, 2006, 8:28 pm - IP Logged|
rank would only give a number value to the hits count
there are some special uses of rank, however... instructions here...
could be a tricky formula is needed, I'm still brushing up on formulas (creating your own) so I'll have to get back to you on this one... manually, you could select the 2 columns, click on SORT and pick the 2nd of the 2 columns in descending order, this would put the high counts at the top with their corresponding digits (but only if both ranges are selected)... that's how I do quick imports from state lottery games, copy their descended order list and re-sort it by date ascending (so I have newest draws at the bottom)
Playing more than one ticket per game is betting against yourself.