How to Randomize a list

Hi, I have a sheet which has 2 or 3 columns with a sequence of data in it. I want to update that data in random. how to do so?

Could you please provide a sample?

you can use as =rand() for any of the no

or randbetween(bottom, top) in where u can give random no limit as if you want random no between 10 to 20 use bottom as 10 and top as 20


many thanks
rishi Saw

I have to update this sheet every month, but with different name on different date.
Every month I have to update this sheet, I want a formula or technic from which I can randomize this sheet.

use this

=DATE("2013",RANDBETWEEN(1,12),RANDBETWEEN(1,31))

pls note u have to use f9 key for refresh and I took 2013 as default date if you want you can rand maize year also...


many thanks
Rishi

thanks rishi,
but where to put this formula in my sheet?
Can you please upload my sheet after applying this formula?

Ok then see the file, hope it works for U

Azumi

Hey Sameer

u can put =DATE("2013",RANDBETWEEN(1,12),RANDBETWEEN(1,31))

on b5 and inter ( use f9 key for refresh the dates)

also pls note I took as 31 as default last date of month see the colored no and you can change as per our required..


many thanks
rishi

@Azumi

thanks for your new way of approach ..... really nice

rishi.... same way your formula is good too bro.......

Regards

HI guyz.....
Thanks a lot for your help.

Happy to help Isameer.....

my pleasure