I use the RANDBETWEEN function all the time whenever I need to create a sample data set.

The cool thing about the RANDBETWEEN function is that if you don’t like the numbers that it has given you, you can press F9 in a cell and it will give you new numbers.  Try it out by downloading the sample workbook!




Helpful Resource:



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Vlookup in an Excel Table What does it do?Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array.Formula breakdown:=VLOOKUP(lookup_value, table_array, col_index_num, )What it means:=VLOOKUP(thi...
INDIRECT Function Using Sheet References What does it do?Returns a reference to a cell, or a range of cells of a sheet.Formula breakdown:=INDIRECT(ref_text, )What it means:=INDIRECT(Return the referenced range, Omit if the reference is an A1 style or enter FALSE if it is a R1C1 style)The ...
INDEX Function Introduction The INDEX function in Excel returns a cell´s values from within a table/array.It works like a map, so you have to select a range (table/array) and tell it to return you the coordinates (Row & Column numbers).So if you want to return values from a Price List or large d...
Excel´s TEXT Function The TEXT function in Excel allows you to convert a numeric value to a specific format by using special format strings.If you have a date and want to show just the month or if you have a large number and want to show it in a thousands format , then the TEXT function is your sa...