Creating a summary list of larger dataset

[jkiser]

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?

 

[ryguy7272]

You may want to rethink your design. Some samples here:
http://www.vertex42.com/ExcelLinks/cat/excel-templates-payroll-scheduling-1.html

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

HTH,
Ryan--