Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a value and then suppressing ALL rows WITHOUT the found va | Setting up and Configuration of Excel | |||
Shortcut for hide/show detail in grouped columns/rows | Excel Discussion (Misc queries) | |||
Suppressing zero value display in print-out | Excel Worksheet Functions | |||
Hi all!! Suppressing the "Do you want to save changes" | Excel Worksheet Functions | |||
sorting detail rows - summary row in an outline | Excel Discussion (Misc queries) |