errors

=LOOKUP(9.99E+307,'BALANCES - CC'!$C2:INDEX('BALANCES - CC'!2:2,MATCH(9.99E+307,'BALANCES - CC'!2:2)-Z$2)) I have no idea... I thought Lookup wanted to find a specific SOMETHING within a specific range. But the range is what I don't get. The portion above: INDEX('BALANCES -...

How can I underline or highlight spelling errors as I am entering text data ? Can I do this without a script? If so please tell me how. If I need a script THANK YOU IN ADVANCE if you would kindly share it with me. Thanks

I run an export every month from Quickbooks - it is for accounting actuals for my company. It's a horrible format and not meant for external users. I'd like to create a more user-friendly template where, when I export the data, it automatically populates into my template as well. This would...

I am trying to copy a table from Excel and paste as an image to PowerPoint. For some reason, the copy/paste methods error out about 1 in 10 attempts to run the code. :confused: I added GoTo error handling but the code seems to be ignoring it. On the line...

Hello everyone, I'm working on a code snippet in order to save my useform entry into my Access sheet. The code is <code><code> Next ctrl If IsNull(str) Or str = "" Then MsgBox("Record Saved") DoCmd.RunCommand acCmdSaveRecord -- line that is highlighted when code errors out...

Hi All, I’m sure there is an easier way to do this. I wish to compare multiple cells (not in a range) to a single criteria, i.e. having data in every second column (from B) compared to criteria C3, and every second column (from C) data compared to a different criteria C2. This works but it's...

Hi, I want to find the maximum length of each field taking into account of errors that pop up. For example I have data in cells A2:B938, Column A is the ID number and Column B is a description, I am using the following formula to get the max length: {=MAX(LEN(A2:A938))} and similarly B2:B938...

I'm at a loss on this. I need to find the Overall +/- performance % of errors made over the 4 quarters of the year. I can get the performance +/- from the previous quarter but the overall is a mystery. My data is: 1st 2nd 3rd 4th 50% 67% -55% -78% Keep in mind that positive % =...

My aim is to insert multiple pivot tables on one sheet. but i cant do this as there are errors popping out. Please help me this

I have a program that requires a lot of Workbook.Save and Workbook.Open operations through out the day. Most of time the program works ok, but once or twice a week, it stops with "fail to open / save object" errors on the Workbook.Save or Workbook.Open line for no obvious reasons (such as...

Good morning. I am trying to write the following, and I keep receiving a #DIV/0 error or the formula just errors: If D2=0 or D2/E2<1.5 then "Yes" should populate otherwise, the cell should be blank. Any help is appreciated.

Hello Everyone, have a quick question about adding onto the formula below. Sheet1 H5=IFEROR(INDEX(Sheet2!$AK$3:$AK$13,MATCH($B5,Sheet2!$A$3:$A13,0)),"") To have it process the below? In sheet 2 Column A is a list of companies and AK2 = Total of errors for each of the companies AL2 =...

Can you please assist with the following? I am trying to count the number of errors by pay types in columns E to J in tab “REF. DAILY DATA” If there is more than one error in one day, count 1 error per day, see highlighted in yellow. Thanks in advance

Hi, I have web queries which fetch table into excel but sometimes the table URLs don't exist... I.e - when the tables have no data yet How can I handle these errors so that if table isn't found or has no data >>> then it's skipped Any help appreciated

Hiya I've attached a picture for reference. I'm currently at work and have been trying to figure this out for hours. So my task is to figure out which person made how many of each mistake. As you can see to right I can easily find out how many mistakes total were made by each person, but now I'm...

Hi everyone, sorry for language misstakes first, but i'll try to do my best to elaborate problem. I have some problem with detecting "errors" in formulas. I have table with simple formula, example, in cell F6 is "=ROUND(D6*E6;2)". How can i check that in that cell F6 are exactly D6 and E6, or...

So I have some code that checks input data for errors and highlights the errors and displays that, it also currently counts the errors and gives a total. What I'd like to do is add some kind of VBA that when an error is found it would write the specific error to another sheet (tab) in the same...

Hi all, I am struggling a little to make a COUNTIFS or SUMIFS formula work on my spreadsheet. I am trying to count the amount of errors made depending on the category. I have the scores in one tab and the table containing the number of errors in another. So.... My current formula is below...

Hello, I have this formula so far - I need it to look at the dates field, and say if the date is a month end date then to put a number 5, if not a month end date then to do a networkdays formula. I have this formula - although it is not working and giving errors. any insight is appreciated...

Hello everyone, I keep trying to achieve a formula that allows me to sum some cells in a different sheet than the one I wanted posted so I've developed a code such as this one below: I keep getting syntax errors and so on no matter how I switch it up, I need some help! :(