Results 1 to 4 of 4

Thread: Extract data from a Table

  1. #1

    Extract data from a Table

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I have a table containing the data of audits of companies by Rating Agencies (in last 03 years). My boss asks summaries of these audits. I attached the table and the summery report format.

    Can u guys help me to do this?


  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Excel Version
    Office 365
    I suggest adapting the table to have the following columns
    No, Company,Year, Rating agency, Type of audit, Month Company Rating
    Then extracting it with a pivot table

  3. #3
    Try this formula in D9


    then copy down and across

  4. #4
    BTW, best to put a data validation list in D5 with the company list.

Tags for this Thread

Posting Permissions

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