Aug 12 2021 03:49 PM
Hey!
for one of my excel courses, we were learning how to use MODE.MULT array. I has to use that formula twice on different cells with a different range for each. (See picture)
For Column F (in blue), it worked as intended. However for Column E (in red), for some reason the same formula is giving me a spill error.
What could've caused this and how do I fix it?
Thanks in advance!!
M.