Lottery Function

Hi,
I'm new and dunno if this is the right place to post this, or if what I want is possible... but here goes.

Basically I wanna simulate a lottery. 1-49, selecting 6 numbers. I'd like it if the numbers selected would be in numerical order (i.e. if the 6 numbers went from A1:F1, A1 would be the smallest, F1 would be the largest) and some way to search for an entire combination. Some way to get a new load of numbers (like a button) would be good too. A bonus number would be an extra cool feature but isn't 100% necessary.

Thanks if anyone can help with this.

Cool, that's great, thanks.

Just to help my understanding of this sorta stuff, how does it get the results from the random numbers??

B1:H1 get the positions of the seven smallest random numbers in the list using the SMALL function with the position argument (1 to 7) taken from the header row.

B2:H2 put B1:H1 in ascending order, again using the SMALL function and the numbers in the header.