| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mix up names
What is the formula and how to:
To change the names from alphabetical order to being shuffled. Excel 2003 Thank You Leland |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mix up names
In a helper column put
=RAND() Copy down and then sort the sheet on that column. Leland5491 wrote: What is the formula and how to: To change the names from alphabetical order to being shuffled. Excel 2003 Thank You Leland |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mix up names
Bob I am very new at this. What is a helper column?
How do I do what you said?? :-) Bob I wrote: In a helper column put =RAND() Copy down and then sort the sheet on that column. What is the formula and how to: [quoted text clipped - 4 lines] Thank You Leland |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mix up names
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. Leland5491 wrote: Bob I am very new at this. What is a helper column? How do I do what you said?? :-) Bob I wrote: In a helper column put =RAND() Copy down and then sort the sheet on that column. What is the formula and how to: [quoted text clipped - 4 lines] Thank You Leland |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mix up names
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 I wrote: 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? [quoted text clipped - 12 lines] Thank You Leland |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mix up names
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. Leland5491 wrote: 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 I wrote: 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? [quoted text clipped - 12 lines] Thank You Leland |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
| Can I check names in one list agains names in another in excel? | Excel Discussion (Misc queries) | |||
| how do I find names in a workbook full of names | Excel Discussion (Misc queries) | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Linear Mode
