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!

    Guys,

    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?

    Book1.xlsx

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    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

    =INDEX(Table!$C$5:$AC$14,MATCH($D$5,Table!$B$5:$B$14,0),(COLUMN(A1)-1)*3+ROW(A1))

    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
  •