» Generate a random value between two limits in Microsoft Excel
CATEGORY - Other Q&A Formulas
VERSION - All Microsoft Excel Versions
Enter the following values in cell A1 and A2: 65, 84 (these
values will act as the lower and upper bound limits)
Enter the following formula in cell B1: =RANDBETWEEN(A1,A2)
A random number between 65 and 84 will be generated
Book Store:
randbetween
John Posted on: 31-12-1969
1- install Analysys ToolPak
2-in cell A1 enter a bottom number, in cell a2 enter the top number
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
actually, what I'm looking for is a "formula" that will generate, for example, 24 non repeating numbers between 1 and 24.