| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multicolumn adress file. want to sort on last , first name
how do i do it.
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
multicolumn adress file. want to sort on last , first name
Hi,
could you provide an example of your file "bdcochran" wrote: how do i do it. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
multicolumn adress file. want to sort on last , first name
Last First Telephone Address Suite City State Zip Code Personal Notes |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
multicolumn adress file. want to sort on last , first name
"Eduardo" wrote: Hi, could you provide an example of your file "bdcochran" wrote: how do i do it. Last First Telephone Address Suite City State Zip CodePersonal Notes |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
multicolumn adress file. want to sort on last , first name
Hi,
Insert and empty row between the titles and the first row with Data, then highlight the total range from the column containing the Last name to the one containing the notes, then go to Data Sort and select the column which have the last name choose Ascending or descending If this helps please click yes, thanks "bdcochran" wrote: "Eduardo" wrote: Hi, could you provide an example of your file "bdcochran" wrote: how do i do it. Last First Telephone Address Suite City State Zip CodePersonal Notes |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
multicolumn adress file. want to sort on last , first name
Last First Telephone Address Suite City State Zip CodePersonal Notes I have multiple people with the same last name. I want to alphabetize the list so that the information is by last name and then the multiple people with the same last name have their information in first name order. I cannot figure out how to do descending on two columns at the same time. Yeah, I can alphabetize by last name alone. Then the first names are in random order. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error with adress function | Excel Discussion (Misc queries) | |||
| Transferring items between multicolumn listboxes | Excel Discussion (Misc queries) | |||
| Can Excel Adress Envelopes? | Excel Worksheet Functions | |||
| SUM using results from an Adress-formula | Excel Discussion (Misc queries) | |||
| How do I print my adress list? | Excel Discussion (Misc queries) | |||
Linear Mode
