Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by compudevil
-
scrambling cells row wise in excel!!!
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- compudevil
- Post #20
- Forum: Microsoft: Office
-
scrambling cells row wise in excel!!!
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...- compudevil
- Post #18
- Forum: Microsoft: Office
-
scrambling cells row wise in excel!!!
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...- compudevil
- Post #14
- Forum: Microsoft: Office
-
scrambling cells row wise in excel!!!
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...- compudevil
- Post #12
- Forum: Microsoft: Office
-
scrambling cells row wise in excel!!!
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...- compudevil
- Post #6
- Forum: Microsoft: Office
-
scrambling cells row wise in excel!!!
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 ...- compudevil
- Post #4
- Forum: Microsoft: Office
-
scrambling cells row wise in excel!!!
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...- compudevil
- Thread
- Replies: 19
- Forum: Microsoft: Office
-
scrambling the numbers in excel
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- compudevil
- Post #3
- Forum: Microsoft: Office
-
scrambling the numbers in excel
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...- compudevil
- Thread
- Replies: 2
- Forum: Microsoft: Office
