Unique random numbers

Excel 2010

I want to generate 10 numbers all between 1 and 100 inclusive.

I believe this does that:

Please Login or Register  to view this content.

However I am not sure how to make them all unique from each other at each page refreash

Any help will be appreciated

dave

One of several ways:

List the numbers 1 to 100 down a column, and in the adjacent column, =RAND()

Sort by the latter column and use the first 10 numbers.

dave,

Attached is an example workbook based on the critieria described.
In column J are the numbers 1 to 100
In column I is the formula: =RAND()
In column H is the formula: =RANK(I1,$I$1:$I$100,0)+COUNTIF($I$1:$I$100,I1)-1

Column H uses the random numbers in column I to give each random number a unique rank, from 1 to 100, in a random order. Column A then grabs the top 10 random numbers.