Lmorse3Copper ContributorDec 04, 2023RANDARRAY with specific amountsI am wanting to do a RANDARRAY but I want to use specific amounts. I want it to be 5 rows by 4 columns and I only want the amounts to be 20, 40, or 60. Is there a way to do this?HansVogelaarDec 04, 2023Lmorse3 Yes: =20*RANDARRAY(5, 4, 1, 3, TRUE)
HansVogelaarMVPDec 04, 2023Lmorse3 Yes: =20*RANDARRAY(5, 4, 1, 3, TRUE)Lmorse3Copper Contributor to HansVogelaarDec 04, 2023HansVogelaar THANK YOU!!!!!!! I really appreciate it.
Lmorse3Copper Contributor to HansVogelaarDec 04, 2023HansVogelaar THANK YOU!!!!!!! I really appreciate it.