• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Query - I would like to populate a table based on the values in a pivoted table

    Hi, Can anyone please take a look at this please? - Kaustubh
  2. K

    Query - I would like to populate a table based on the values in a pivoted table

    Luke, I would need your help once again. Your suggestion to my question worked handsomely but now I have another similar kind of requirement. I modified my code you gave me last time so work like this: =IF(COUNTIF(Non_Critical_Monitor!A:A,A8)=0,"Server Not...
  3. K

    Query - I would like to populate a table based on the values in a pivoted table

    Thank you so very much Luke. That one worked wonders!! :). I really appreciate your help!! :) _/_ - Kaustubh
  4. K

    Query - I would like to populate a table based on the values in a pivoted table

  5. K

    Query - I would like to populate a table based on the values in a pivoted table

    Here is an excerpt from the first pivoted data sheet. This is my sheet 2 (the pivoted table) and my first sheet is the same as above. sDisplayName sMonitorTypeName sMonitorTypeDescription (Placeholder?) AQUA3 AQUA3 - AOL Jobs Monitors the ETL jobs on AQUA3 RPC...
  6. K

    Query - I would like to populate a table based on the values in a pivoted table

    I would like to populate an excel sheet with the values that are there in another adjoining sheet (The excel file is the same). The issue here is the data in the adjoining sheet table is pivoted. So what I want is: Sheet 1 (Columns): Server_Name, Oracle - Category backup etc Sheet 2 (Columns)...
Back
Top