I have 3 equations i have tried, i am trying to do an index match with month and year but they are all returning #N/A
=INDEX('Operating Modes'!C6:O150,match(month(B7)='Operating Modes'!B54:B150)*(year('semi annual'!C3)='Operating Modes'!A54:A150),MATCH('semi annual'!C4,'Operating...
I have the following code in F5 that looks at the EVENT date and checks if each row is in the date range (F:G), then counts each unique ID number and this works great.
However, I now want to add another check to this, which is if the "check days" (D) is >=5 it should ignore that row (ID) (or <5...
Hi
I just watched a video in which he said Transpose() is an array function. I tried to google list of array functions in excel but all what I go how to use CTRL+Shift+Enter to make array formula. My question, are they functions in excel called array functions? or array can be used with any...
I watched this video and modified the formulas. This will extract the missing values from between the minimum and maximum in the range (sorted or not) into either a single cell or a range of cells. Function TEXTJOIN requires Excel 2016, I think.
Is there a superior method...
Ok this sounds weird but I need to know if there is a way to do a ctrl+shift+enter (array) in VBA. I often use application.match in my VBA and want to use it for multiple criteria so I can get the row number match. How do I do this? Thanks
Multiple criteria match in basic formula...
Need some expert help, please. As you can see below, the formula in cell c13 is an array that calculates a 12-day moving average for that data in column B. You can also see that column B has non-numeric data, which is why I'm using the array in C.
Here's my problem. I want the formula in...
Hope I present this problem in an understandable way...
1.) DATA
I have an "up counting", table like this, which restarts the count from 1 "randomly":
<tbody>
Count
2
3
1
2
3
4
1
2
3
1
2
1
2
3
4
</tbody>
2.) GOAL
It is easy to find the maximum: 4
and...
Can anyone please assist me with clearly explaining why I must use CTRL+SHIFT+ENTER for formulas 1 and 2, but not for formula 3?
H1=Jerry
H2=Bob
H3=Tony
Range 'Names' = H1:H3
Formula 1:
{=SUM(SUMIFS(B2:B10,A2:A10,H1:H3))}
Formula 2:
[/CODE]{=SUM(SUMIFS(B2:B10,A2:A10,Names))}[/CODE]...
Hi Guys,
I am trying to FormulaArray in my code and it does not work for formula having more than 255 characters. I have already tried couple of solutionas given on link below and this does not work for me
http://www.excelforum.com/excel-prog...ml#post3932754
Solution on this link does not...
Hi,
I'm having a slight issue with a multiple array formula I am using to copy over data from one worksheet to another.
The formula works ok but as is it a Multiply Array I have to press CTRL+SHIFT+ENTER. However my original spreadsheet has over 15,000 lines of data and as each formula...
Hi,
I try to define an array formula, but the CTRL+SHIFT+ENTER keys don't respond.
So far I already tried:
1. using the CTRL, SHIFT keys both on the right and on the left with all combinations.
2. First writing the formula, then choosing the range and pressing C+S+E => no response.
3. First...
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.