RANDBETWEEN Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel as a spreadsheet program is a magnificent tool for calculating and maintaining small sets of information. In addition, it is easy to comprehend easy data entry and create formulas as well as column names and many more. With its formulas and functions, you can easily create several worksheets at the same time. Thus, you just have to study and learn the basics and familiarize yourself with the functions and formulas such as mathematical, logical and many others.

With the Excel’s functions, RANDBETWEEN function is the one of the most often used functions of Microsoft Excel. This function returns random number integer amidst the numbers of the user had specified. Every time the worksheet has been calculated, new random number integer is being returned. The Syntax for RandBetween function is “RANDBETWEEN(bottom,top)”. The “Bottom” argument is the considered as the smallest integer and the “Top” argument is the largest integer of RandBetween and it will both return.

Selection of Random Names with Microsoft Excel:

Microsoft Excel has the random generator number, which is the key in selecting names randomly. Both randbetween and rand function has the ability of pseudorandom numbers. Pseudorandom number generator is the algorithm to generate number sequences that approximates the random number properties.

Randbetween function is another mathematical function in Excel used to generate random numbers in the user’s worksheet or spreadsheet. There are main differences between the rand and the randbetween functions. These are as follows:

  • Rand function returns back only integers.
  • Randbetween function allows you to determine the beginning and the end points of random number that has to be generated.

All the numbers that are generated by the random functions in Excel can be utilized for different things such as setting up and scientific experimental testing and simulation of dice rolling. Moreover, you can easily duplicate random numbers in a multiple worksheet using the randbetween function of Microsoft Excel.

In Randbetween function of Microsoft Excel, the user can easily use this function to prevent the duplication of the random numbers. Through the use of this formula, “=INDIRECT(“A” & MATCH(RANDBETWEEN(1,MAX(G:G)),G:G,0))”, you can easily avoid any duplication in your spreadsheet. This is a formula for column G. Be reminded that this solution is only required in the Microsoft Excel 2007 and the other latest versions.

Generating the Non-repeating Random Integer Numbers:

Is there any other way to generate a single column that has 100 rows but with the numbers that are similar using the Randbetween function of Excel? Yes, there is. With UDF or the “user defined function”, the user can generate series of random numbers that are non-repeated in Microsoft Excel. This is a great function utilizing statistical analysis; the user needs in generating random non-repeated numbers. This is considered as an accessible function having only three arguments. One is for the possible random number, the other is for the possible lower random number and the last, is for the numeral of random numbers that the user would want to display. Random numbers are separated by a space and it is accessible to use the functions of text manipulations. The non-repetition of random numbers is used for the Excel Macro.

Post comment