Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Tedious formula (Excel 2003)

    If I knew the correct terminology for my problem I would look up the answer in my many manuals.

    Is there an easy way to complete the formula in the attached worksheet? I am sure there must be a quick way.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Tedious formula (Excel 2003)

    You mean like this?

    I changed the sheetnames to match the column headings and added a column (can be hidden) to list what column to "grab". Now indirect can be used...

    Steve
    Attached Files Attached Files

  3. #3
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Tedious formula (Excel 2003)

    Thanks Steve. I will have to learn about Indirect now.

    Did you see the tables at the bottom of the monthly stats sheet? Can I do this here as well? If so, start me off with rows 106 - 107 - 108 and I and then I can probably work the rest out for myself.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tedious formula (Excel 2003)

    Is there any chance that you can set up the raw data differently, or are they a given?
    If the raw data would be in a single database-like table, it would be relatively easy to generate all kinds of summaries and charts from the data.

  5. #5
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Tedious formula (Excel 2003)

    Hi Hans

    Hey if you have a better idea go for it! I inherited this godawful thing and have already culled a lot of unnecessary stuff.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tedious formula (Excel 2003)

    See the attached workbook. I didn't try to recreate the summary tables exactly, I just included two pivot tables that were simply created using the Wizard.

    I left the macro that I used to create the data sheet in the workbook for your information; you cannot run it in this copy any more since I removed the original month worksheets.
    Attached Files Attached Files

  7. #7
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Tedious formula (Excel 2003)

    WOW! Now this is going to be interesting. Something I havent seen or done before. I will paw over this tonight at home when I am uninterrupted.

    Thanks Hans ( You always teach me something new!)

Posting Permissions

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