LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default PLS, I need help, it is hard

I receive this doc (below), different names each time. And i need to have the
top one("mo" or whatever (there are no entries next to these)) to be shown
with the sum of the totals below . Then from "name"down to the totals i have
to have it hidden, now here is where it becomes tricky thay are not always
the same size so i can't spesify a certain cell. There are about 30 of these
"mo"'s or whatever. Can someone help

Mo
Name Perc Ovd Exp Tot for Prd
ag 2 4
ng 3 444
ngh 4 446
9 894

gp
Name Perc Ovd Exp Tot for Prd
af 56 363
sdh 242 6
298 369

Need to be shown as:
Mo 9 894
gp 298 369

Thanks
 
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
Hard bar (or maybe other) graph Basil Charts and Charting in Excel 10 August 15th 08 08:30 PM
Hard CR in a Cell Brian Excel Discussion (Misc queries) 2 December 7th 06 12:52 AM
Real hard one PANCAKE Excel Discussion (Misc queries) 7 July 8th 06 12:16 PM
Hard One. Chris S. Excel Discussion (Misc queries) 1 August 23rd 05 10:32 PM
This is a hard one... goodfella Excel Discussion (Misc queries) 4 June 17th 05 06:31 PM


All times are GMT +1. The time now is 03:34 PM.

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"