Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

RANDARRAY with specific amounts

Copper Contributor

I 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?

2 Replies
best response confirmed by Lmorse3 (Copper Contributor)
Solution

@Lmorse3 

Yes:

 

=20*RANDARRAY(5, 4, 1, 3, TRUE)

@Hans Vogelaar 

 

THANK YOU!!!!!!! I really appreciate it.

1 best response

Accepted Solutions
best response confirmed by Lmorse3 (Copper Contributor)
Solution

@Lmorse3 

Yes:

 

=20*RANDARRAY(5, 4, 1, 3, TRUE)

View solution in original post