Forum Discussion

jhalanim's avatar
jhalanim
Copper Contributor
Aug 12, 2021

Excel MacBook - Mode.Mult - Spill error for a specific column only - bug?

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.

Resources