See JE McGimpsey's site.

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


Gord Dibben MS Excel MVP

On Thu, 17 Sep 2009 15:35:53 -0500, "Don" wrote:

I need to create a unique random number from 1-15 in columns D1 thru D15.
There can be no duplicates. It should be a different set of numbers each
time the spreadsheet is loaded. Can someone show me an easy way to
accomplish this?

Don D.