"Adda" wrote in message
...
I have 10 columns of data. I wanted to randomized each column so that I
will
get a new combination of data. Its like permutation but actually applying
it
to the data. is there any function I can use for this?

Assuming your data is in colums A to K, do this

1) Select column B and then select Insert Columns
3) Keep on inserting colums so that every other column is empty
4) Insert =RAND() in the empty columns and dragfill downwards
At this point, you should turn on the recorder if you want to do this random
sort every now and then

5) Select columns A and B
6) Select Data|Sort. Sort on column B
7) Repeat until you have sorted the last column on the column with the RAND
function
8) Hide the colums with the rand formula
9) Turn off the recorder

I think you could get away with two colums with the RAND function. It
apppears as if Data|Sort has a limit on how many columns it can sort. You
would have to do the sort several times and change the selected columns each
time. Either way, you have to sort 10 times.

/Fredrik