|
Posted to microsoft.public.excel.programming
|
|
|
exclude a number from randbetween function
Thanks, works a treat.
"daddylonglegs" wrote:
A formula method...
In A1 =RAND() copied down to A20
in B1 copied down to B4
=RANK(A1,A$1:A$20)
These are your 4 random numbers - hit F9 to regenerate - hide column A
if required
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564478
|