errors

Morning Guys, I have searched high and low for this and still unable to find the solution. I have an auto update (every 5 mins) on a worksheet with charts where it takes info from other worksheets and other workbooks, when all the charts are populated I don't get an error, but if 2 charts don't...

Hello, I am trying to combine an IFERROR statement with an OR condition. The data I am pulling from is a Pivot table, and I've figured out how to eliminate the errors when no relevant pivot row is available, but I also need to change any 0 values returned to a text format hyphen "-" for visual...

I'm trying to modify this field which currently gives a positive result if over or = to 3, then minus 2%. I want it to give a positive result for 3 or over, and equal if exactly 2 with no minus 2%. =IF(ISBLANK(I5),"",IF(K5>=3,(M5*(G5-1))*0.98,-M5)) I would be really grateful for assistance as...

Earlier this month I was trying to figure out how to add a print button to a worksheet to print selected cells as a PDF document - https://www.mrexcel.com/forum/excel-questions/1037201-add-print-button-worksheet-print-selected-cells-pdf-document.html - which as you can see from that thread, I...

I'm not sure if this is possible , if it's not possible please let me know. Any help will be appreciated. I'm trying to extract a list from A if B matches " Yes " without showing the errors , completely ignoring the errors. What I usually use is Index and match to return criteria , but it...

I am trying to clean up data in Power that will eventually be exported into access (achieved employee records). Of the 2866 rows I imported into power query, I have 375 errors in one column and the error reads: DataFormat.Error: We couldn't convert to Time. Details: 1.083333333 *numbers under...

Hi I need a bit of help with a nested IF AND formula. I can get nested IF's to work with no problem, however if I add and into the mix it seems to go awry. The data i have is as follows; <tbody> A B 1 2500 Yes 2 2500 No 3 1200 Yes 4 1200 No 5 1900 Yes 6 1900 No </tbody> The...

Hi, I have a data table that tracks errors being made and there are 4 column headings called 'rejection cause (1-4)' so that multiple errors can be recorded against the same work item. These columns are populated with text info (from a drop down list). I'm trying to build a pivot table that...

I have inherited a spreadsheet with countless formulas like this: =IF(ISNA(MATCH(A1,MatchRange,0)),"n/a",INDEX(IndexRange,MATCH(A1,MyNamedRange,0))) Obviously I could change these to: =IFERROR(INDEX(IndexRange,MATCH(A1,MyNamedRange,0)),"n/a") But I thought that instead I might just not bother...

I need a little help please, I have a large list of employees, each month they make mistakes in processing I have a report generated monthly which contains columns relating to their names and the types of error they have made - where each person may have made multiple errors of varying...

Hello all. This will be hard to put an example and I apologize. I have a lot of data on a sheet for November (months worth) for employees based off 7 rows. I then have an error sheet where I have the errors listed for all employees. What I am looking to do... I have a sheet called Employee...

Hi everyone, I"m still new in VBA and currently working on to develop data entry form in excel. I'm facing errors where my ID cannot auto increment while inserting the data=Country with 10 rows once the button was clicked. My codes are getting errors by overwritten the previous data for next...

So I am using the following formula to take a data set and standardize it between 0 and 1: =(U2-MIN(U$2:U$301))/(MAX(U$2:U$301)-MIN(U$2:U$301)) I have a data set I want to use the above formula on, BUT it has #VALUE ! errors in the set. I want the formula to just run the calculation for each...

I am creating a report with 75 different survey results and I am trying to find the averages of each of the answers. I am working on the formula and I keep getting errors. Here is what I have (I'll spare you all 75 and only input 10)...

Hi there, I have a macro which I need to try and debug... I can identify the various errors, but is it possible to resume the macro if certain errors are picked up? I can then weed out which errors are the issues and tend to them applicably. This is the code I have so far: On Error GoTo...

After registering this great book at QUE , how do i find which content is updated. I found the inside cover to be misleading , especially Actually nothing is delivered, instead one has to login to view :( I expected an ebook/pdf with highlighted content of omissions / errors or references to...

I am writing a macro to refresh all queries in my workbook and want to handle errors during the refresh like this with something along the lines of: On Error Resume Next ActiveWorkBook.RefreshAll If err.Number <> 0 Then Msgbox "Errors detected" Else Msgbox "No errors" End if...

I just want to copy from one workbook to another but I always get errors ranging from Application defined or Object defined errors to compile errors to the paste area must be the same size as the copy area, I didn't realize how hard copying and pasting something would be. This is my code so...

I need expert advice on a fix. There was a "re-scale" button created from developer that was used to update a Charts on a slicer. Now that I go in a refresh the data, I get debugging errors (11 of them) because I believe all these charts are being affected. How can I remove the errors and be...