includes

  1. C

    sumproduct sumifs multiple criteria

    I currently have a sumproduct sumif formula pulling wildcards and want to change it to sumifs where it only includes values <0. Here is my current formula: =SUMPRODUCT(SUMIF($C:$C,"*"&{"ACORNS"}&"*",$D:$D)) i tried changing it to this, but it returned 0, when there are definitely values for...
  2. S

    Import JSON into Excel 2019

    I have a Powershell script that pulls all of the Outlook Email Rules in our Office 365 Domain. I would like to output it to JSON as CSV drops columns. I have the export working fine but cannot seem to get the data to load into Excel. I have followed several videos on how to go to Data --> Get...
  3. S

    COUNTIF not working

    In my DEV tab I have a column which includes a look up that will be £0, <£10,000, <£100,000, <£1,000,000, <£10,000,000 or >£10,000,000. The formula I am using is =COUNTIFS('DEV WIP'!J:J,"<£10,000,000") - however, this is not counting - please help!
  4. R

    Iserror Match if one of two cells includes text

    I am trying to return a value if one of two cells includes text by using "IF(ISERROR(MATCH" formula. I've added the OR function to try to do this but a value is not being returned even if one of the two cells includes text. Here is my formula...
  5. auto.pilot

    Seeking method to identify changes month over month

    I'm seeking a VBA method to identify changed values month over month. My spreadsheet has about 80,000 rows. Column H includes month-end dates, column C includes unique ID numbers that never change and column E includes values that may change every month. I am attempting to highlight rows in...
  6. R

    Complex Array Adjustment

    Hi, I have the below formula in cell a15/c15 which works great. However, I need to add an additional criteria from the second data set which also looks at column C and includes UK only. Can anyone help? Thanks in advance Ryan https://www.dropbox.com/s/wpyf5051jvv68ff/Forumla%20Help.xlsx?dl=0
  7. D

    List of Monday's excluding Holidays

    I am trying to prepare a list of Monday's which excludes any holidays lists but I can't seem to get it to work. I tried the WORKDAY function but then it skips the Monday and returns the Tuesday. Example Cell C4 is the previous Monday 10/02/17 And holidays are listed in cells J5:J30 which...
  8. aaaaa34

    deleting rows which includes some words

    hello my friends, in my worksheet, i want to delete entire rows which includes "Corners, Yellow cards, Red Cards" words also i want to delete upper and lower rows of that row which we delete (these rows don't need to include any specific word, just i need to delete them too). pls have a look...
  9. S

    Highlight cell where formula is overwritten

    Hi I am trying to write a code where if someone keys over a formula in a cell so it is now value, the cell is highlighted. This includes if the cell also is linked to any additional files. Any ideas? Thanks

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