Results 1 to 2 of 2

Thread: Format problem

  1. #1
    Join Date
    Mar 2005

    Unanswered: Format problem

    Please refer to attachment. I currently have a realtively large data set approximately 500 line items. In the format as shown in the sheet titled 'Current format' and i need it in the format as per sheet 'desired forma'. Is there a way to automatically change the format, rather than individually rearranging the fields
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2003
    Ottawa, Canada

    Solution using Drop-Down Lists and SUMPRODUCT


    See the attached workbook. A simple solution using drop-down lists and the SUMPRODUCT function.

    Hope you like it

    To learn more bout drop-down lists and SUMPRODUCT visit my website at:
    Attached Files Attached Files
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick

Posting Permissions

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