I am evaluating a payroll report in which every person has multiple
entries...one for each paycheck they've received. The number of entries per
person is different depending on how they're paid.

I would like to create a summary list with a single line for each name and
position.

For reasons I won't get into, I can't use the subtotal feature.

Question...is there a formula that I can use to create this summary list?

You may want to rethink your design. Some samples he
http://www.vertex42.com/ExcelLinks/c...eduling-1.html

Here are some more ideas for managing data (SubTotals are included in the
tutorial):
http://aim.path.org/en/excel/advance...elAdvanced.pdf

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"jkiser" wrote:

I am evaluating a payroll report in which every person has multiple
entries...one for each paycheck they've received. The number of entries per
person is different depending on how they're paid.

I would like to create a summary list with a single line for each name and
position.

For reasons I won't get into, I can't use the subtotal feature.

Question...is there a formula that I can use to create this summary list?