Reorder/shuffle values in a row/column in Excel.

Question

Is it possible to shuffle randomly, values in rows or columns in a excel sheet. Is there any function/macro for that? How do i do this?

-ad.

Answer 1

Hm... just as simple solution without programming. For example, you have a column of data (A):

23
78
12
78

Just add another one column - B. Each cell of column B must be a function RAND():

A     B
--    --
23    =RAND()
78    =RAND()
12    =RAND()
78    =RAND()

Now you can sort rows by column B and get desired solution.