• 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.

Recent content by AZExcel

  1. A

    Pivot Table Assistance Large Data Set

    P45cal, Wanted to thank you for sharing your knowledge. I have been moving which is why there is such a gap in this entry. Having said that, I have been reviewing your submissions going into the Power Query editor, and watching videos on Power Query and now I feel like I am starting to...
  2. A

    Pivot Table Assistance Large Data Set

    p45cal Thank you for the reply... I am reviewing your latest submission to learn what I don't know. I really appreciate your assistance. CHEERS!! AZExcel
  3. A

    Pivot Table Assistance Large Data Set

    P45cal, Love the Logo or Avatar you use.. anyway.. what was the reason Power Query was necessary to address the problem, and is there a way to include all the questions in this data, for example: how did employee A do with the question in column H or Column I, etc?
  4. A

    Pivot Table Assistance Large Data Set

    P45cal Thank you for your reply.. I was in Hawaii for a few days and got busy.. I will take a look and see what I can learn.. I really appreciate your time AZExcel
  5. A

    Pivot Table Assistance Large Data Set

    Hello, I have a Pivot Table challenge that I don't have the skill set for. The File is a sheet from a Google form Quality Assessment that we need to be able to measure by questions and responses in columns AX-BA. Further, the ability to measure the count and percentages by the employee per...
  6. A

    Variable Sum and Avg based on 2 criteria in table

    Peter, Thank you for helping me with this project. I see that your work accurately sums up the dates that are selected on each side of the sheet. This was exactely what I needed. In addition to adding up all the factors from point A to point B ( so to speak) I will need the Avg. I should be...
  7. A

    Variable Sum and Avg based on 2 criteria in table

    Thanks, Peter I will take a look to see if I can apply it to my situation.
  8. A

    Variable Sum and Avg based on 2 criteria in table

    Peter, Thank you for taking the time to respond to my question. But the solution you offer is outside of my skill level. How would I go about applying the above?
  9. A

    Variable Sum and Avg based on 2 criteria in table

    Hello, I am working on a project involving determining a factor based on a CPI table. The solution I am seeking involves 2 pieces of data, one of which I have worked out using match and index and some other formulas. The 2nd part is a little more challenging. I need to be able to select...
  10. A

    VBA Not Working On Work Computer

    Narayan You would think the article would provide that information, but it does not. However, I just figured I can see where the file is located on my home computer and try to duplicate this at work. Thanks again for your Assistance.
  11. A

    VBA Not Working On Work Computer

    Narayan, You pointed me in the right direction as usual. Microsoft Common Controls -2 6.0 had "MISSING" in front of it. I was kinda hoping it was something in the VBA rather than some missing reference files. I really don't understand anything about this type of situation. Someone from...
  12. A

    VBA Not Working On Work Computer

    Thanks Narayan I will check under tools, references to see if the above references are missing from my work computer. If not, I will download/register them. I will report back to the group.
  13. A

    VBA Not Working On Work Computer

    Hi I don't know if this is a common problem but I cannot get a tool that I am working on at home to function at work. I have been working on a tool using a little bit of VBA code at home and when I try to use the tool at work I get error messages referencing a missing library. I am not very...
  14. A

    Searching Cells with Multiple Contents

    Most excellent explanation indeed @NARAYANK991 .... I can feast on this for days and certainly referred to it often. Many thanks Somendra, Azumi and Srinidhi as I have benefited from all of your input!!!
  15. A

    Searching Cells with Multiple Contents

    Somendra, Your solution works perfectly. Thank you for your time and knowledge. I have been studying the formula to try to gain an understanding of how you arrived at the answer. Can you tell me what SMALL(IF(ISNUMBER(SEARCH does in this formula and...
Back
Top