3 Digit Numbering for Raffle Tickets....

Hello and Thanks,

I'm trying to figure out how to set up an Excel spreadsheet to generate random 3 digit numbers for a daily number lottery ticket.

I want the numbers to start at 000 and go to 999 but in a random order with no repeated numbers. Each number will need to be in its own cell.

I will eventually need 4 columns with 250 numbers each, but I can copy and paste them from one column. Also, I don't want it to recalculate the sheet every time I open it.

Any help would be greatly appreciated.

Many, many thanks,

Tenorman

Melvinrobb,

Many, many thanks...Amazing!

Tenorman

Nice work Melvinrobb! (You'll probably want to copy and paste as values column C to avoid recalculation when reopening once saved.)

Pete