includes

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

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

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!

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

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

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

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

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

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