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

Please drop the all caps. Hard on the ears.

Thamks


Gord Dibben MS Excel MVP

On Sun, 21 Sep 2008 09:10:01 -0700, HARSHAWARDHAN. S .SHASTRI
wrote:

WHAT I NEED IS RANDOM NUMBERS SAY 1 TO 10 IN CELLS A1:A10 AND CONDITION IS
THAT NO NUMBER SHOULD REPEAT.
CAN ANY ONE GIVE ME SOLUTION.

THANKS

HARSHAWARDHAN.SHASTRI

INDIA