Need Formula for control the random

[The Wraith]

Hi

--1-- I've x-cells each with same random formula
--2-- Those x-random numbers goes to x-seperated cells
--3-- In groups of 6 i need different numbers in those x-cells

So i need formula to check the seperated cells of different numbers.
(so 2 checks 1/3 checks 2/4 checks 3 etc...)

How can i :
Let cell2 know to check the random number in cell1 ....??
((if cell1=cell2 then run random again in cell2)) els next cell..

If cell3=cell2 then run random cell3 afgain..else go to cell4
etc

How can i put this together in a correct formula ??
random formula together with the (check formula)
or in seperated cells ??


Thx.

 

[Dave Peterson]

J.E. McGimpsey has a nice userdefined function at:
http://www.mcgimpsey.com/excel/randint.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm