Forum Discussion
Structured Reference
Professor and I cannot figure out why I got this formula incorrect in the assignment. I am including pictures of the instructions and the excel sheet with the formula filled in M2. She will e...
SergeiBaklan Thank you for telling me how to do a screenshot on the computer. I did not know how to do that. I have never posted on here before and I am trying to do it the best I can. I do not know what information if needed to get help because I do not know what I did wrong.
Screenshots: - you may pin to taskbar Snip & Scatch or/and Snipping Tool, but work. Or use shortcuts to use them.
Excel difference: - template is made for Excel 2016 which doesn't support Dynamic Arrays, and you are on Excel 365 which is more modern one and has Dynamic Arrays by default. Most probably the difference was since in some of formulas implicit intersection operator @ was missed. In some cases that could give different results (if no error appeared).