| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping rows based on header cells
Hi,
I have a question that I'm sure will have been asked before, but I can't for the life of me find it by searching - all i find is information on using Data Sort. The problem is, after manipulating some personnel data, I'm left with the following layout of information: Column A .... DEPARTMENT: Human Resources Adam Brown Cecil Davies DEPARTMENT: Finance Elliot Farthing Gary Holmes Ian Jacobs DEPARTMENT: Human Resources Kris Lambs DEPARTMENT: Finance Mark Namara .... Column B is blank for the Department rows but contains personnel ID numbers for the employee rows. What I want to do is sort/group this information by department and their corresponding employee ID's. ie: .... DEPARTMENT: Finance Elliot Farthing 123 Gary Holmes 456 Ian Jacobs 789 Mark Namara 246 DEPARMENT: Human Resources Adam Brown 810 Cecil Davies 121 Kris Lambs 416 .... Can anyone please tell me how to go about doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highting rows based on content of cells | Excel Worksheet Functions | |||
| Conditionally summing cells based on conditions in other rows | Excel Worksheet Functions | |||
| grouping rows with blank cells | Excel Worksheet Functions | |||
| List rows in an order based on a cells value | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
