Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
*Using Office 2007*
I am using the sort function to organize a list by date and anniversary year. That works well. Then I insert blank lines (for readability) between groups of dates according to weeks on the calendar. No problem. Next, I want to sort the names alphabetically within the anniversary year and week. Each time it asks if I want to expand the selection. I say yes so that all of the data (name, anniv. year, anniv. date, job title, job location) stays together for each entry. Sometimes this works. Sometimes it doesn't. When it works, just the names of associates celebrating 10 year anniversaries for week 3 are alphabetized (for example), then I alphabetize the names of associates celebrating 20 year anniversaries). When it doesn't work, excel disregards the blank lines that I placed and alphabetizes my whole list - no longer separated by weeks of the month. (it clumps them all together.) i hope this makes sense. How can I get it expand the sort to JUST the section that was highlighted? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
making a portion of reference to a worksheet variable in a formula | Excel Discussion (Misc queries) | |||
HOW DO I SAVE A PORTION OF A WORKSHEET ON A FLOPPY DISK? | Excel Worksheet Functions | |||
HOW DO I SAVE A PORTION OF A WORKSHEET ON A FLOPPY DISK? | Excel Worksheet Functions | |||
excel prints only a portion of my worksheet | Excel Discussion (Misc queries) | |||
Sorting a portion of a range | Excel Worksheet Functions |