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