Microsoft Excel is a powerful spreadsheet application featuring formulas used for organizing, calculating and formatting data. It’s usually bundled by Microsoft in their Office Suite, which is compatible with other Microsoft Office applications such as Word and Outlook. Excel is used in almost every business, by almost every Excel consultant, in almost every part of the world.
There are over one hundred Excel functions. One of the Excel’s functions is the RANDBETWEEN function. 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 Excel 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 such as Excel 2010 and 2011 (Mac).
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.
Do you need help with Excel 2013 (Excel 150, we have articles, videos, and more on that, or we can upgrade your 2013 systems for you. Just give us a call, we are in the Irvine area of Orange County California. 714.262.6893, 877.392.3539.