Generating Random Phone Numbers

Often when you are writing code or testing an application, it might be helpful to have random phone numbers generated for you.
Here is an excel formula that I use: =value(left(substitute(rand(),”0.”,”"),10))
try these 2 instead (thanks to John)
=RAND()*(9999999999-1000000000)+1000000000
=RANDBETWEEN(1000000000,9999999999) [needs analysis toolpack add-in or excel 2007]
Even though it works most of the time as excel rand() formula generates [...]

Sorting a list of items in random order in excel - using formulas

In shuffling a list of items in excel I have described the technique of using random numbers generated by RAND() to sort a list of items. The technique had one disadvantage though, every time you need to reshuffle the list you have to press F9 to recalculate the rand() and then go to menu > [...]

Simulating Dice throws - the correct way to do it in excel

If you ever had to simulate random outcomes in excel sheet, you might have already heard of about the spreadsheet function rand(), this little function generates a random fraction between 0 and 1 whenever you use it. So I usually write =round(rand()*12,0)int(rand()*12)+1 if I need a random number between 0 to 12. Of course, if [...]

Shuffle a list of numbers / items in excel spreadsheet

Here is a quick Monday tip for data junkies.

If you want to shuffle a list of numbers or cells in excel in random order you can do that with “data > sort” menu option of excel.

First insert a column next to the list you want to shuffle and enter random numbers in each [...]

Worst bar chart ever? - World’s Most Expensive Places to Have Sxx

Environmental Graffiti should get the award for “worst possible bar chart ever” for this unbelievable piece of art…
Who said bar charts are only for serious data interpretation, they can be used to have such fun
Also read Garr Reynold’s comments on this as well. Happy Thursday..