After you put it in the first cell, r-click and "Copy" the cell. Now
select the cells in ALL the rows below it and then "Paste" in to all
the cells in the column at once. 10- 1000- 10000 whatever.
I see how that works.
Now is there a way that I can copy that to 1K or 50K names all at the same
time??
Bob said:
helper column is the empty column adjacent to your data.
put =RAND() in the first row and then copy it down to the rest of them
then highlight all the data (names and helper column) and pick Data,
Sort and then sort on the helper column.
Bob I am very new at this. What is a helper column?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.