relates

Hi, A user is having issues trying to open a file with the below macro code. I don't believe this is an issue for anyone else. The code and error are both below. Does anyone have an idea of what this relates to? Thanks in advance Ryan Private Sub Workbook_Open()...

Hi all, our part numbers are entered onto Excel, and the cells are formatted as "text" in order to keep the part numbers in their original format. Which is great, until we run a macro and the parts lose their formatting and return to Examples 000456 becomes 456 1.10000 becomes 1.1 I sort of...

<tbody> 2019 2019 2019 Result Flag Result 1234 54 51 77 5678 14 #N/A 101 #N/A =SUMPRODUCT(Sheet2!$B$3:$D$4*(Sheet2!$B$1:$D$1=B$1)*(Sheet2!$B$2:$D$2="Result")*(Sheet2!$A$3:$A$4=$A3)) </tbody> I'm using the above SUMPRODUCT formula on a large dataset. In testing we...

I am trying to average a range of cells that represent a rating (Column B) to interview question responses (Column C). The ratings are 0-5 (0-V Bad, 5-V Good) As some interview questions won't be asked the rating will be zero, but could also be zero if the interviewer rates the answer as 'very...

I'm using Power Query to load 10 tables to the data model. I noticed that my workbook has a PivotCache count of 4. Is it normal for PowerPivot to generate multiple caches or have things gotten duplicated? Is there any way to find out which queries each cache relates to? If I try...

It comes up with 2 error messages. I don't know what this the second error message relates to "Remove records..... sheet2.xml" - please help. Imgur: The most awesome images on the Internet Imgur: The most awesome images on the Internet