REVERSING NAMES AND SORTING

  • Thread starter Thread starter jonco
  • Start date Start date
J

jonco

I have a list of between 6 and 10 names that I regularly have to reverse
(display last name first) and sort.
They have corresponding data attached to each name that needs to be sorted
also.
For example:
First name would be in Row 44 let's say.....

Col L Col M Col N Col O Col P
Col Q Col R Col S Col T
Row Name Hours Gross Fed SS
Medicare State city Net
44 John Smith 39 457.60 81.10 13.66
7.25 6.95 4.57 365.00
45 Jane R. Doe 40 319.97 72.10 11.44
6.15 5.20 3.19 258.77
46 and so on......

Final result needs to be like this:
44 Smith, John 39 457.60 81.10
13.66 7.25 6.95 4.57 365.00
45 Doe, Jane R. 40 319.97 72.10
11.44 6.15 5.20 3.19 258.77
46 and so on......

Any and all help would be appreciated.
Jonco
 
Hi Jonco-

From what I can tell the only thing that keeps you from _easily_ doing what
you want is that you have First & Last name stored in a single cell. If each
is in a separate cell you could just click in the Last Name column an use
the Sort Ascending (A-Z) or Sort Descending (Z-A) Buttons on the toolbar.
You could also use the Data>Sort command to sort on as many as three fields
(columns).

Although there are other ways, with only 10 records it would probably be
easiest to Insert>Cells adjacent to the current Name column and edit your
records to include First Name and Last Name as separate fields (you may also
want to include a Middle Name or Initial column)

HTH |:>)


I have a list of between 6 and 10 names that I regularly have to reverse
(display last name first) and sort.
They have corresponding data attached to each name that needs to be sorted
also.
For example:
First name would be in Row 44 let's say.....

Col L Col M Col N Col O Col P
Col Q Col R Col S Col T
Row Name Hours Gross Fed SS
Medicare State city Net
44 John Smith 39 457.60 81.10 13.66
7.25 6.95 4.57 365.00
45 Jane R. Doe 40 319.97 72.10 11.44
6.15 5.20 3.19 258.77
46 and so on......

Final result needs to be like this:
44 Smith, John 39 457.60 81.10
13.66 7.25 6.95 4.57 365.00
45 Doe, Jane R. 40 319.97 72.10
11.44 6.15 5.20 3.19 258.77
46 and so on......

Any and all help would be appreciated.
Jonco
Click to expand...

-- (e-mail address removed)
 
Back
Top