| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetize sets of rows within a WB
Hi all
I have a list of files I got from my IT dept to review. The list shows the directory and then the files in that directory. Unfortunately the files are not alphabetized under the directory heading. I currently have each directory and file as a seperate row. Is there a way to alphabetize a set of rows, then alphabetize another set of rows without mixing the sets? To further complicate things, there could be any number of rows (files). I can make the directories an unique string that could indicate a start/stop point. Example Data as recieved K:\PMC\BECKY\ File D.doc File A.doc File C.doc File B.doc K:\PMC\DAN\ File E.doc K:\PMC\STEVE\ File E.doc File A.doc File Z.doc Result K:\PMC\BECKY\ File A.doc File B.doc File C.doc File D.doc K:\PMC\DAN\ File E.doc K:\PMC\STEVE\ File A.doc File E.doc File Z.doc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows to columns with multiple sets | Excel Worksheet Functions | |||
| Can I use Sort to alphabetize & leave blank row bet. rows (2003) | New Users to Excel | |||
| Recognizing sets of rows | Excel Discussion (Misc queries) | |||
| Grouping According to Sets of Rows | Excel Worksheet Functions | |||
| How do I set up different column widths for sets or rows? | Excel Discussion (Misc queries) | |||
Threaded Mode
