=Randbetween() is part of the analysis toolpak.

Tools|addins

(Depending on how you installed excel, you may need the installation CD)

Mac wrote:
>
> I'm having a few problems with the formulas but I'm trying to fumble
> through them. I'm not a whiz at Excel which doesn't help much.
>
> D2 seems to have trouble with the
> MATCH(RANDBETWEEN(MIN($A$2:$A$300),MAX($A$2:$A$300) part which I
> haven't been able to solve yet. For E2 and F2 it was returning a
> #NAME? so I changed $D2 to $D$2 and now it returns #N/A, which is
> probably waiting for the D2 formula.

--

Dave Peterson