Suppressing detail rows

D

da

Hi
Is there any way I can suppress the details and show only the sub-total for
each employee, without going thru each name and hiding or deleting the detail
rows?
I want to show only the total hours worked and amount paid for each employee.
thanks

26 AUTRY BRUCE Police Operations 5.00 $301.80
26 AUTRY BRUCE Police Operations 5.00 $301.80
26 AUTRY BRUCE Police Operations 10.00 $603.60
51 MENSAH SAI Security and Access Control Unit 7.00 $257.39
51 MENSAH SAI Security and Access Control Unit 7.00 $257.39
51 MENSAH SAI Security and Access Control Unit 7.00 $257.39
51 MENSAH SAI Security and Access Control Unit 7.00 $257.39
51 MENSAH SAI Security and Access Control Unit 7.50 $267.75
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $285.60
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 8.00 $294.16
51 MENSAH SAI Security and Access Control Unit 219.50 $7,943.15
64 ZANNELLA GARY Security and Access Control Unit 5.50 $215.60
64 ZANNELLA GARY Security and Access Control Unit 5.50 $215.60
71 VIRGO MARK Security and Access Control Unit 5.00 $183.85
71 VIRGO MARK Security and Access Control Unit 5.50 $196.35
71 VIRGO MARK Security and Access Control Unit 5.50 $202.24
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $190.40
71 VIRGO MARK Security and Access Control Unit 8.00 $285.60
71 VIRGO MARK Security and Access Control Unit 8.00 $294.16
71 VIRGO MARK Security and Access Control Unit 104.00 $3,637.40
 
P

Pete_UK

Set up your print area so that it only covers these six columns. Then
in the next column (G2) you can enter this formula, where I have
assumed your data starts on row 2 (with a header row):

=IF(A2=A3,"","subtotal")

Copy this down to cover your data. Then you can apply Autofilter to
this column, and select "subtotal" from the filter drop-down.

Hope this helps.

Pete
 
Top