Couple of ways:

http://www.mcgimpsey.com/excel/randint.html

In article ,
"ExcelFan" wrote:

How do I generate random numbers from 1 to 100 without any repeated numbers?
Am using Excel 2003.