Recent content by AZExcel

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

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

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?

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

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

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

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

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?

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

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.

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

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.

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

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!!!