Can anyone suggest the best way to randomize a column?
C Claus Busch Jan 5, 2015 #2 Hi, Am Mon, 05 Jan 2015 15:19:07 +0000 schrieb Saxman: Can anyone suggest the best way to randomize a column? Click to expand... make a helper column and write =INT(RAND()*30)+1 and copy down. Modify the 30 to the number of entries you have and then sort by helper column Regards Claus B.
Hi, Am Mon, 05 Jan 2015 15:19:07 +0000 schrieb Saxman: Can anyone suggest the best way to randomize a column? Click to expand... make a helper column and write =INT(RAND()*30)+1 and copy down. Modify the 30 to the number of entries you have and then sort by helper column Regards Claus B.
S Saxman Jan 5, 2015 #3 Hi, Am Mon, 05 Jan 2015 15:19:07 +0000 schrieb Saxman: make a helper column and write =INT(RAND()*30)+1 and copy down. Modify the 30 to the number of entries you have and then sort by helper column Regards Claus B. Click to expand... Thank you Claus. Happy New Year to you and all other members of the group.
Hi, Am Mon, 05 Jan 2015 15:19:07 +0000 schrieb Saxman: make a helper column and write =INT(RAND()*30)+1 and copy down. Modify the 30 to the number of entries you have and then sort by helper column Regards Claus B. Click to expand... Thank you Claus. Happy New Year to you and all other members of the group.
C Claus Busch Jan 5, 2015 #4 Hi John, Am Mon, 05 Jan 2015 16:06:37 +0000 schrieb Saxman: Happy New Year to you and all other members of the group. Click to expand... you are welcome. Also for you a Happy New Year Regards Claus B.
Hi John, Am Mon, 05 Jan 2015 16:06:37 +0000 schrieb Saxman: Happy New Year to you and all other members of the group. Click to expand... you are welcome. Also for you a Happy New Year Regards Claus B.
