How to Randomize Data in Excel/Spreadsheets

Question

Can someone tell me how to randomize data in a spreadsheet, respective of each criteria?  I don't want my businesses showing up under phone number, etc.  I pretty much just want to randmoize the order.  Thanks.

Answer 1

One way to set up an easy random scramble

Assume data to randomize is in A1:A10 (can be text, numbers or mix data)

In B1: =RAND()

In C1: =INDEX($A$1:$A$10,RANK(B1,$B$1:$B$10))

Copy B1:C1 down to C10. Hide/minimize col B.

C1:C10 returns the random scramble of A1:A10's contents.

Press F9 to re-generate a fresh random scramble

Answer 2

Add a column, enter =RAND() and copy down, then sort by that column.

Answer 3

Hi,

 you can also use the function =RANDBETWEEN(bottom, top)  in case you want the random number to be in between two numbers 

Ex:- if you want the random number to be in between say 10 and 20, use =RANDBETWEEN(10,20)

HTH

Prakash