| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Multiple Entries
I have a list of pay records in rows, with an employee ID# in column A for
each one, which they are sorted by. An employee may have multiple entries each. What I want to do is use formatting to easily show where one employee's records end and another begins. I am using "sumif" to create totals for each employee -- KKD |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Grouping Multiple Entries
on the menu bar: Data Subtotals will group and subtotal for you
"KKD" wrote: I have a list of pay records in rows, with an employee ID# in column A for each one, which they are sorted by. An employee may have multiple entries each. What I want to do is use formatting to easily show where one employee's records end and another begins. I am using "sumif" to create totals for each employee -- KKD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Selection when Grouping columns | Excel Discussion (Misc queries) | |||
| GROUPING IN PIVOT - MULTIPLE CONSOLIDATION RANGES | Excel Discussion (Misc queries) | |||
| Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
| Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
| Grouping entries in a catalog | Excel Discussion (Misc queries) | |||
Linear Mode
