LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
DA DA is offline
external usenet poster
 
Posts: 104
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding a value and then suppressing ALL rows WITHOUT the found va Tom Setting up and Configuration of Excel 4 February 2nd 08 10:00 PM
Shortcut for hide/show detail in grouped columns/rows Corey Excel Discussion (Misc queries) 1 November 20th 07 12:06 AM
Suppressing zero value display in print-out Gary D. Excel Worksheet Functions 3 October 13th 07 08:49 PM
Hi all!! Suppressing the "Do you want to save changes" Bony Pony Excel Worksheet Functions 2 February 2nd 05 11:39 AM
sorting detail rows - summary row in an outline ExcelSteve Excel Discussion (Misc queries) 1 December 5th 04 02:40 PM


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"