errors

  1. C

    Problem with "Excel found a problem with one or more formula references in this worksheet", unable to find error

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

    Combine IFERROR with OR statement

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

    Coulkd someone help me correct this please?

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

    Intermittent 400 and 1004 VBA errors with a macro to save the active worksheet as a PDF file

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

    Extracting a list with Criteria with no errors if criteria not matched.

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

    DataFormat.Error

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

    Nested IF AND

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

    Pivot table - counting data in columns with same heading

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

    Does filtering out errors speed up Excel?

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

    Return value that most often occurs adjacent to another value

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

    Some assistance - 1 workboot, multiple sheets

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

    id not auto increment and data overwritten using loop

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

    Ignoring #VALUE errors in a formula?

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

    Averaging cells in multiple worksheets

    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)...
  15. RobbieC

    Error message handling and resuming...

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

    Excel 2016 VBA & MACROS - Content Update

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

    VBA Error Handling with ActiveWorkbook.RefreshAll

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

    Help pasting to another workbook

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

    DeBugging errors on all charts in the slicer

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top