View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Attie Attie is offline
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