excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi,
i want to generate a random number/s from a list/range c2:h3,
but,
a-i got error of #ref
b-how to i choose the amount of rand numbers returned?
c-is it possible to eliminate duplicates based on the second range? c5:h6
(if in j2 i got 5 i want exclude it in j5)
i want to generate a random number/s from a list/range c2:h3,
but,
a-i got error of #ref
b-how to i choose the amount of rand numbers returned?
c-is it possible to eliminate duplicates based on the second range? c5:h6
(if in j2 i got 5 i want exclude it in j5)
Cell Formulas | ||
---|---|---|
Range | Formula | |
J2,J5 | J2 | =INDEX(C2:H3, RANDBETWEEN(1, 6)) |