failed

  1. D

    help with formula

    Hi Everybody, I know this is one is probably an easy one for you all. I have a long error report I need help with. Attached is a sample of the spreadsheet. Column J shows where the error is located on the spreadsheet. Is there a way to highlight the row where the error shows up? For instance...
  2. V

    VBA Loop formula

    Hello all Can I have help please on this loop please. I want to complete a sumifs statement in cell "D9" and then replicate this every 4 cell down in column "D" until I get to cell "D2597" Tried to put this together but failed Dim i As Integer Range("D9").Select i = 1 Do Until i > 2597...
  3. M

    Macro works on first go around, then doesnt work correctly until excel is closed and openned again....only to work once.

    So I am trying to create a button that opens a userform thatasks questions on what the user wants to do. It is kind of hard to explain so Iam going to try to insert screen shots of what I want to happen. Below is part of a table that is created on the main pageentitled “Status Sheet.” <tbody>...
  4. R

    IF statement quick help.

    I have the below formula =IF(AND(OR(H2="#N/A",I2="#N/A", J2="#N/A")),"FAIL","PASS") In the results it either brings "PASS" when passed or shows "#N/A" when failed. How can i get this to say PASS when it's passed and FAIL when it's Failed?
  5. T

    Time Interval Formula

    <tbody> Item 260 A/C 2121 Date failed: 15 May Fault: B60 Item 260 A/C 2121 7 May B60 Item 260 A/C 2003 3 May B60/CS Item 260 A/C 2103 6 Jul B60 </tbody> I'm trying to build a table that pulls from another automatically and checks to see if my equipment items have failed...
  6. A

    IF statement

    Hi, Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible. scenario: Total number of items = 39 For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and For each item...
  7. A

    IF statement Help

    Hi, Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible. scenario: Total number of items = 39 For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and For each item...
  8. F

    Pastespecial method of range class failed 1004

    Hi, I have 2 sets of code. One copies the form and the second pastes it. (the ancillary functions are sheet hide unhide etc) The problem is, at times the codes work perfectly fine. But sometimes i get the "pastespecial method of range class failed 1004" error. I have created an excel ribbon...
  9. A

    Multiple if statement with vlookup

    Hi, I have this formula below where I would also like to add if B3 = "3rd Party", then have the same result as Contractor, I've clearly failed trying AND/ OR functions. Please could you help? =IF(B3="Contractor",VLOOKUP(C3,'Rate Card'!A:M,13,0),VLOOKUP($B3,'Payroll by Person Mar-18'!A:M,13,0))...
  10. F

    runtime error 1004 pastespecial method of range class failed

    I keep getting this error "runtime error 1004 pastespecial method of range class failed" on following code : Option Explicit Sub copypasterow() ' ' chequerecieving Macro ' copy active row to another workbooks last row ' ' Keyboard Shortcut: Ctrl+l ' Dim wbTarget As Workbook...
  11. S

    quick question on chart axis selection in VBA

    Hopefully a quick question all The following line of code is failing Sheets("ChartByCount").FullSeriesCollection(5).AxisGroup = 2 I get a runtime error; "Method 'AxisGroup' of object 'Series' failed" Must be a syntax problem or something equally simple, but I can find the problem Any help...
  12. M

    Power Pivot Data Model Error

    Hi, When trying to load a table into the Data Model using Excel 2013 I get the following error message: "Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.WorkbookClass' to interface type 'Microsoft.Office.Interop.Excel._Workbook'. This operation failed because the...
  13. Y

    Similar code worked in the first sub but failed in second sub

    Hi All, I tried to create two slicers by Slicercaches.add2() methods. it worked for the first slicer but failed for the second one. I tried every way i could use: put them in a same sub, use two subs, record a macro then paste it in my code. All failed. Can anyone help? Thanks.
  14. I

    Power Query Fails to Convert Data Type, Error Persists

    Hello, I have a power query pulling from a CSV file. I have set the data type in one of the columns as text, but there are errors that claim power query could not convert the data in the column to a number. I have tried refreshing the query. I've tried converting to a different data type then...
  15. B

    can anyone help me with code

    Sheets("INPUT").Protect Password:="runway", DrawingObjects:=True, Contents:=True, Scenarios:=True Except "AE:AT , X "COLUMN need to add to above code,rest of the cells need to be protect i tried but getting failed Anyone can help me out
  16. L

    How to get the row number of bottom usedrange?

    <colgroup><col></colgroup><tbody> As new set of cells has to be copied at the bottom of existing used cells, but the VBA code below is failed (far lower than my used range), </tbody> <tbody> a = ActiveCell.SpecialCells(xlLastCell).Row </tbody> <tbody> please advise the code. </tbody>
  17. B

    An Elusive Table with chosen data from multiple worksheets

    Have a workbook with 70 different worksheets, all the worksheets are the same "Form", all these forms have a "comments" section (cells A35:G36), and a cell F32 which if an X is placed in it, indicates a failed inspection. Trying to add a table to the main page in essence a summary of failed...
  18. L

    IF(And Statement

    Hello- i am having some difficulties creating a formula to help me figure out the forecast accuracy and fulfillment rate with different if scenarios. Forecast accuracy column: If forecast is 10,700 and i sold 8,108 that mean i over forecasted by 24%. Also, if my forecast is 85 but i sold 176...
  19. A

    VBA: get CentreHeader from sheet

    I searched in the Internet and I found tons of stuff related to setting Header/Footer (Left, Right, Centre). However, I am trying to do the opposite and I have not succeeded. What I need is to get the text (ONLY THE TEXT) from CenterHeader. The text of CenterHeader was "Greece". I run the...
  20. B

    Countif formula

    I am having a student data to calculate the number of subjects failed by a student. ABSENT is also considered as fail and those who have scored below 50 marks is considered as Fail. The excel sheet designed is as follows: Roll No Name Subject 1 Subject 2 Subject 3 Subject 4 Subject 5...

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