"Neil Higgins" wrote:

How do I generate random numbers in a column of cells but avoid duplications.
i.e. Every cell contains a unique whole number from a specific range.

Chip Pearson has a good one he
http://www.cpearson.com/Excel/randomNumbers.aspx

The "no duplicates" version is about midway down the page...