errors

Hi, I am trying to delete rows that have a zero value in column E. I have tried various methods and keep getting 'object does not support this property or method' or 'type mismatch errors. Currently I have: For deleterow = .Range("E" & Rows.Count).End(xlUp).Row To 1 Step -1 If .Range("E" &...

Hello, I have in Q118, this formula...

With help I got here some time ago, I was able to build a table that shows how often a string from a master list occurs in a reference list. <tbody> R/C C D E F G H 4 Master Tally Reference # Errors Type Formula in D 5 jane 2 jane sally polly 0 D5: =COUNTIF($E:$E,"*" & C5 & "*") 6 Joe 3...

Hi All, I have a sheet that is used for reconciling information from 2 sources. This includes a column that I only want filled with a pasted value, as one user insists on typing the amount in manually and invariably ends up making some errors. Is there a way I can lock these cells so they...

I am trying to calculate the number of remaining errors in a list of total errors, sorted by type of error, as follows. I have tried both COUNTIFS and SUMPRODUCT with no success. Help Please!! Target Cell for the formula is I1. I need it to calculate the number of cells in column I table...

This is best explained with an example. We have a daily error file that shows vouchers that have exceptions. A single voucher line can generate multiple errors. Sometimes this is because there were multiple things wrong with it, and sometimes because a single root cause can throw multiple...

I am using Power Query to review an Excel file and look for any error values (such as #NA , #VALUE , etc.). When PQ imports these, it converts the cell to Error. If returned to the Excel worksheet, these cells become null. I'd like to know if it's possible to have PQ actually return the cell...

Hi all, Bit of background, I have a live football scores/fixtures/events spreadsheet with a lot of API queries which generally works well, however, occasionally, when querying the API, there are errors in response which Excel flags up in a message box with an "OK" button. Not sure what the...

Evening all something simple - maybe someone can explain why the the below errors out Sheets(Array("Sheet2", "Sheet3", "Sheet4")).Range("A1").CurrentRegion.Clear

Hi, My latest question, to me, seems much simpler that what i have previously asked, but i cannot get through it without label not defined errors, endif without this that and the other errors I need a short piece of code that if the result of a particular cell (AA99) on Sheet33 is 1000001 then...

=COUNTIFS($CA:$CA,$CA3,CR:CR,"<"&CR3)+COUNTIFS($CA3:$CA3,$CA3,CR3:CR3,CR3) with this, which I'm using to rank numbers within a range, it works very well, except for the fact that the errors in column CR are not appearing as errors Currently they are appearing as numbers (the total number of...

Hi All, I'm using windows 10 with Excel 2016, where I'm trying to import information from another *.xlsx file. Real basic stuff, however I'm getting errors like crazy. Can anyone help? I feel like Windows 10 has robbed me! Thanks, Pinaceous

Good morning, I have the following formula that adds up COUNTIFS from multiple sheets utilizing a column header search (MATCH). The issue is that the Column Header may not appear on certain sheets. When this happen, the formula errors out. I have heard of the use of IsError to add 0 if there...

I am attempting to automate errors in data using conditional formatting. My intent is to automate highlighting errors when cell data vary. Highlight cell F2 if F2/B2 > 1.5 I've tried several formula variations and cannot get this right. Any formulas that have worked for you?

Hi, For a few days now i have been having problems whilst making forms etc. Some good members here has advised the code or edit to use but when i copy from her & paste into my sheet i see errors etc. The member who put the advice here did not see any errors at all & as such worked 100% for...

Hi, I'm new to the forum and am hoping I can get some help. I'm trying to search a worksheet for anywhere an error check (all error check calculations are labeled as such) is being done and then showing that either the error check calculations show no errors or show that there are errors being...

I am just starting with JavaScript in Excel, and I have downloaded the "Excel JavaScript UDFS" book from this site. I have installed the sample add-in, but I have a problem with the RangeAverage function: With a large range (e.g. 1 column x >500,000 rows) it returns #NA #. After returning this...

Hello, trying to put together a sparkline using a a non-contiguous range and getting errors, any ideas on how to achieve this?

I am getting an error at the worksheetfunction.average line when I run this macro because of div/0 errors in the data. It runs fine when there are no div/0 errors in the code, so everything else is fine. I just need a way to be able to ignore the div/0 in the data, and preferably to filter out...

Hello, I have a macro written that collects values into an array, then I do various statistics on them - average, st dev, max, min. The macro collects data from over 500 workbooks in a folder, taking out specific data, and entering into another workbook database. From there I put the data into...