|
Suppressing detail rows
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 |
Suppressing detail rows
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 On Jan 12, 11:34*pm, da wrote: 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 |
| All times are GMT +1. The time now is 12:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com