Recent content by compudevil

Hello AnotherHiggins,....I found out the software DIGB which is compatible with excel,....where all the numbers can be mixed in one go.....It takes time depends on the size of file. Thanks for your help for =rand functions which I am still using for some other purpose,.... thank you very much

Hello AnotherHigins,....I have just started this and excel for me is very new,....u mentioned something about date which I m not getting what u trying to say,...can u please explain me again in different way so I can apply that formula again,.... Please correct me if I am wrong somewhere as I m...

Hello, Say my numbers are in column A B & C. I use =Rand() in the column D and sort it in that same new column and for Rows I Put =RAND() in a different row (instead of column), then select the two rows to be sorted and go to Data > Sort > Options. Then under the Orientation section, choose...

Hello, Friends, I have tries =Rand() formula as been told by anotherhiggins which is helping me doing only 3 rows at a time but What If I got millions of datas in one sheet???..... I want to Jumble the following numbers for example.Column wise we can jumble the numbers but cannot jumble row...

Well, I want to create millions of numbers(numbers as mentioned above) and wants to write it on a CD. When that datas is opened again then no one should recognise that the numbers are dragged and are in series one after the other. So I want the numbers to be anywhere in the sheet. Is there...

Hello Friends, I tried =Rand() which helps me doing the rows but It will do only for 3 rows maximum. Imagine I have 25000 numbers in excel which got 5000rows and 5 columns. now I want to jumble in such a way that no one should recognise that the numbers are dragged in series. For eg ...

Hello FRIENDS, When using =rand() formula, it will scramble the cells column wise. Is there any other way where we can jumble up all the cells row wise. Basically my all numbers are dragged so I dont want them to look in series, so I want to jumble up all the cells ups and downs Can anyone...

tO:ANOTHERHIGGINS!!! Hey thanks man,....it worked. I m doing dat coz I dont wann ne1 know that numbers are dragged in series,...so i want to jumble all ups and downs,....If therz other way round where I can do the same than lemme know as well,...thanks mate Appreciated,... P PATEL

Hello, I want to scramble the cells containing the telephone numbers. I used the scramble software but it scrambles the numbers including the numbers in one particular cell which make my telephone number look bad,.. Is there any other way where I can jumble all the telephone numbers...