Odds of matching from a pool of 21

[ido]

(08-16-2013 10:31 PM)Frank Wrote:  To reply to Ido re- a spreadsheet with 400 random lotto draws in it...

Its still not clear what you want. What you asked doesn't make sense. You seem to want 400 random draws and a REAL draw result on top ? Can't you type in your own real result ?

Here is a spreadsheet to generate 400 random draws, we'll start from there ...

Can you use it? Modify it ? what's missing ? Let me know.

Hi Frank ,thanks a lot,it's OK now and
even works just as expected.
I've simply supposed the bellow:

1/it's a twice weekly lottery data
2/line n.400 is a Wednesday one
3/line n.400 has been generated first

Thanks again,soon the test posted