Is there a way to do a random sort of a column containing text values? Thanks!! tdp
T tdp Nov 17, 2003 #1 Is there a way to do a random sort of a column containing text values? Thanks!! tdp
B biff Nov 17, 2003 #2 Hi tdp, With the text in column A, in column B enter this formula and copy down as needed: =RAND() Then select both columns and do a sort on column B. Biff
Hi tdp, With the text in column A, in column B enter this formula and copy down as needed: =RAND() Then select both columns and do a sort on column B. Biff
