Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetizing within a group of same names in XPExcel2002 column?
I am working on a roster and have more than 5,000 rows of names, classes they
graduated from, the date they graduated and so forth. In my roster, the last names are alphabetized. But within the columns, for instance, there are eight people with the last name of Adams. But "Wilbur" comes before "George" and I need to get those first names (within those same name groups) alphabetized. When I try to cut and paste or cut and insert, I get an error message stating that Excel can't shift nonblack cells off the worksheet and for me to try to locate the last nonblank cell by pressing CTRL+END...etc. Help! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
Pivot table - don't group names | Excel Discussion (Misc queries) | |||
Find a group of names in a long list | Excel Discussion (Misc queries) | |||
Importing data to column from column with differnet names | Excel Discussion (Misc queries) |