View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bookmdano Bookmdano is offline
external usenet poster
 
Posts: 16
Default Display when subtotaling.

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?