Forum Discussion
Have a cell recalculate
I'm having an issue in excel. Lets say I have a cell choose a random number, between 1 and 100, but if it chooses one specific number, something like 20, it will choose a different random number unti...
Using Excel 365 Insider beta there are things called Lambda functions.
= RANDλ(20)
where RANDλ is defined by
= LAMBDA(exclude,
LET(
r, RANDBETWEEN(18,22),
IF(r=exclude,RANDλ(exclude),r)
)
)This is not for the fainthearted!
question is if cl1234 has access to insider
- Very unlikely. Do you?
At present, many Excel users would not even recognise my solutions to their problems as being Excel, never mind whether they are correct. All I might hope to do is dent the complacency that assumes that what was done in the past is the only way!