Thread: Display when subtotaling.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default Display when subtotaling.
You can use a pivot table instead of subtotals

http://www.contextures.com/xlfaqPivot.html

--


Regards,


Peo Sjoblom

"Bookmdano" wrote in message
...
I am subtotaling by account numbers and would like to display both the
account number and account titles.
Spreadsheet looks like:
AcctT, Acct#, SubAcct#
Cash, 001, 01
001, 02
001, 04
When I subtotal by acct number I get "Total 001". The subtotal function
doesn't give you an option to display additional data. I would like to
display the Account Title also. Any simple suggestions?


Reply With QuoteReply With Quote