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...
how about simply creating a list without 20, and making the cell pickung up a value from the list?
in this case you would have let's say 1,2,3...19,21,22,...100 in cells A1:A99, and formula could be =INDEX(A1:A99,randbetween(1,99))
in case the missing number varies, this won't be a solution, but if it is a fix list, then the workaround would surely do.
in this case you would have let's say 1,2,3...19,21,22,...100 in cells A1:A99, and formula could be =INDEX(A1:A99,randbetween(1,99))
in case the missing number varies, this won't be a solution, but if it is a fix list, then the workaround would surely do.