Forum Discussion
Different Results between Professor's Excel and My Excel.
Hello Excel community! I am currently taking an indepth Excel course at school and I had points taken off for a question on a test I got wrong. The question was basically what happens when you input ...
It seems your professor is ignorant of the latest developments in Excel.
Your version is a subscription of Office 365. Recently Microsoft introduced dynamic arrays into the monthly channel which changed the behavior of array formulas.
Dynamic array formulas and spilled array behavior
Dynamic array formulas vs. legacy CSE array formulas
Dynamic array formulas in non-dynamic aware Excel
In my opinion you should get the full points for the question.
It looks like lot of professors are still on Excel 2016 since they have a lot of training materials built for this version. That's a headache to generate another set for DA Excel and keep these sets in parallel.