From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Discover new formula capabilities with new functions and dynamic arrays

Discover new formula capabilities with new functions and dynamic arrays - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Discover new formula capabilities with new functions and dynamic arrays

“

- [Lecturer] If you're working with Excel 2 using the Office 365 version, 3 and you have the latest updates, 4 you do have available to you new ways of working 5 with certain kinds of formulas. 6 Look in the Formula bar. 7 You see this embedded in braces, 8 this is what's called an Array Formula. 9 And in order to make an Array Formula work, 10 you have to press Control, Shift, Enter. 11 Now, long story short, 12 Array Formula is often involved dealing with data 13 in parallel fashion. 14 If I double click cell E13, you see what we're trying to do. 15 In prior versions of Excel, 16 in order to make this answer here be correct, 17 or even sensible, you can't just press Enter, 18 you would've had to have pressed Control, Shift, Enter. 19 We don't need to do that anymore. 20 I'll simply press Enter now, we have a correct answer. 21 Over in columns J and K, 22 we're tracking orders and shipping dates, 23 over here…

Contents