1. J

    Sum values in column O until empty cell is reached whilst excluding "NO" values

    Hi all, Hoping someone can help me with this query. I have a workbook I am working on that currently sums all the values in column "O" if the value on the same row in column "L" is "WP" or "BS" until an empty cell is reached. I would like to expand upon this formula so that it still sums like I...
  2. J

    Countif value is not blank and less than 70% of adjacent cell"s value

    Hi all, Hoping someone can help me with this. I'm guessing it super simple, but I can't find a solution anywhere online. Basically, what I'm trying to do is count the number of times each cell in a range (G4:G9) is not blank and is less than 70% of the value of the cell that is 2 columns...
  3. J

    How to sum values in column D until a blank cell is reached and if values in column C equals "WP" or "BS"

    Hi everyone, I'm hoping you can help me with an excel formula to solve a problem I'm stuck on. I think I am pretty close to solution but just can't crack what it is I need to make the formula work how I would like. Basically, the problem is this: My formula is pasted all down column B. I need to...
  4. R


    XTYPE outputs the precise data type of a cell/range or the elements of an array beyond the resolution of Excel's TYPE() or CELL("type",) XTYPE was designed to provide detailed and high-resolution information about the data type that a cell or cells of a range/array contain. Thus, it is...
  5. M

    Find average when other column reads "true"

    Using Office 365 on Windows 10, When column A is TRUE, I want to find the Average of column B. I know I use could Filter, but I want to create a formula instead. Can someone help...
  6. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  7. M

    Match formula to exclude criteria

    Hello! Wondering if could have feedback on writing a formula that excludes specific criteria from a list. I started a formula that saysIF(ISERROR(MATCH(cellA1,lookupcolumn,0))=FALSE. I’m confused by ISERROR. That essentially returns true if there is an error or false? I want to write a formula...
  8. CsJHUN

    VBA slideshow-ish

    Hi guys i would like to create a userform, which load pictures from a folder, and change the pictures every 3-4 seconds, while the user can select between 2 option button ( good or not good). And the picture name,the selected option button value would be registered below each other. The 'sleep'...
  9. V

    Save file as folder name/sheets as file name

    Hi I would like to change this code to save the file as the folders name instead of "Total Results.xlsm" Also I'm trying to name the worksheets the same as the files that its importing instead of "Data" & i +1 Thanks a lot to anyone that can help Sub ImportCSVData() Dim wb As Workbook Dim...
  10. S

    VBA help to copy rows when key words are selected

    Hello, I use the below code to transfer rows from the "LOG" Tab to the "RTN HISTORY" tab when "SCRAP", or "RELEASED" in Col Z is selected from the drop down. My question is how would I have it transfer back to the LOG tab if "HOLD" is selected from the dropdown? Thanks for all...
  11. T

    Len() function

    Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMissingInfo As String Dim strMsg As String If IsNull(Me.[Debarred]) Then Cancel = True strMissingInfo = strMissingInfo & "Debarred" End If If IsNull(Me.[Restricted]) Then Cancel = True...
  12. G

    Optimize VBA copy/paste

    Hey guys, I am basically trying to make my code run faster, I am trying to convert a section of the code that copies and pastes data across two workbooks to be faster and cleaner. Here is the original paste/copy data: Sub WALLCERTIFICATE()' ' Macro2 Macro ' Dim M As Workbook Set M =...
  13. L

    CountIf True

    =COUNTIF(Data[Column1],TRUE) I have the above mention formula but i want to modify it to add that if Counts of Assets in BU is blank dont count the true now is counting 1,221 but it should be 1177
  14. S

    Slight alteration to VBA code for renaming sheets

    Hi - hoping someone better than me can help with a slight adjustment to the below code. I think its easy for someone with the skills. So it currently opens all the files in a picked folder and renames the sheet to Sheet1, so long as there's only one sheet. Problem is I have a combination of...
  15. L


    =SUMPRODUCT((Raw Data[Count of Assets in BU)*(Raw Data[Column1]=TRUE)) Something is wrong with the formula, what i need is to place the formula in the calculation tab that if header Column1 is true, sum the header Count of Assets in BU that meet the true criteria
  16. B

    Entering a date stamp if a value in cell is True

    Hello everyone, Couldnt seem to find the correct formula for what I am trying to do. In Column O There will be a Yes or a No depending on Checkbox selection on userform. Say cell O2 is entered or changed to true then I want cell P2 to have a non changing date stamp. here is a screen shot of...
  17. T

    VBA: Is there any way to "make all items visible" in a PivotTable Field?

    I recorded a macro by going to a PivotTable, and in the dropdown for the field i was interested in, i checked "Select all)" and then pressed OK. What VBA recorded was this: With ActiveSheet.PivotTables("PivotTable3").PivotFields("Vaca") .PivotItems("excl").Visible = True...
  18. B

    Search for multiple text within a cell and return text

    I'm trying to do multiple text searches in a cell and return text if true. If not true then I want the cell to be blank. For example Column A is PaymentNotFound12345 and I want the formula in column B to search for "PaymentNot" and return "PaymentNot". However I need to also search for other...
  19. T

    Call Command Looks For Sheet & If Not found End Sub

    Hi all, I am after some help, I use the following code to call a sheet and then produce it as a PDF, then it sets up the email ready to send - this is setup for 200 sheets and rather than make the button call up on active sheets where I have not used ' to negate the call. Is there a way of...
  20. W

    Struggling with nested functions

    Can someone please help me to write the following formula? Conditions: if A1 and B2 are blank and A2 and B1 are NOT blank If True: = A2 If False: (leave cell blank)

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