Well..., I don't know how much of a "gambler" you are - but as a "Gimmick"
you are invited to try the proposal in the picture.
Any cell - in range F1:F84 must be blank.
An "X" points that that value was generated more than once.
Cells A1, B1 and F1 should be copied down all the way until row 84.
http://img717.imageshack.us/img717/5083/nonamesi.png
Micky
"Steve Bedard" wrote:
How do you randomly generate numbers from 1 to 84 without duplicates in Excel
2007?