# ctrl+shift+enter

1. ### 3 equations all N/A

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...
2. ### Count unique numbers based on date range and another column of data

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...
3. ### list of array functions

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...
4. ### Extracting missing numbers or dates

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...
5. ### Ctrl+Shift+Enter in VBA

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...
6. ### Moving average in table with non-numeric data

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...
7. ### Minimum of values from index of array values wanted [CSE]

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...
8. ### SUM(SUMIFS( Array CTRL+SHIFT+ENTER Vs. ENTER

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]...
9. ### FormulaArray for formula more than 255 characters

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...
10. ### Trouble with Multiple Array Formula

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...
11. ### CTRL+SHIFT+ENTER don't respond

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

### Which adblocker are you using?

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

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