Results 1 to 17 of 17

subtotal data and include other info from row

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    25

    subtotal data and include other info from row

    Short version: I'm trying to find out if there's a way, when using the Subtotal button in Excel 2007 and collapsing the data to level 2, to show more than just the two pieces of information it defaults to (the field you pick under "At each change in:" and the field you check under "Add subtotal to").

    Long version: I have a monthly project that seems to take more time than I think it should, so I'm trying to find quicker ways to handle it. I have a spreadsheet of people who have donated to our organization and it includes some extra information about them such as their ID. I'd like to include the ID, Last Name and First Name in the Level 2 view (so we can manipulate the data in different ways).

    I attached a sample workbook that includes three worksheets that I think are self explanatory.

    If anyone has any idea if this is possible and how I can accomplish it, I'd really appreciate the help.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1