| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping rows based on header cells
Ingenious! Thanks Dave.
On Sep 19, 9:36 pm, Dave Peterson wrote: I'd try to put the department name on each row. I inserted a new column A. I put this in A1: =TRIM(MID(B1,12,255)) (It returned "Human Resources") Then I put this in A2: =IF(LEFT(B2,11)="department:",TRIM(MID(B2,12,255)) ,A1) and dragged that formula down as far as column B had data. I ended up with: Human Resources DEPARTMENT: Human Resources Human Resources Adam Brown Human Resources Cecil Davies Finance DEPARTMENT: Finance Finance Elliot Farthing Finance Gary Holmes Finance Ian Jacobs Human Resources DEPARTMENT: Human Resources Human Resources Kris Lambs Finance DEPARTMENT: Finance Finance Mark Namara Then I could convert column A to values (select column A, Edit|copy, edit|paste special|values) and do what I wanted with the data...including filtering column B to show only those rows that begin with "department: " and delete those visible rows. |
| 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
