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

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