View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jkiser jkiser is offline
external usenet poster
 
Posts: 29
Default Creating a summary list of larger dataset

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?