Odds of matching from a pool of 21

[Frank]

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.

(Attachment now removed , Ido and 7 others have downloaded)