Apr 21 2021 12:41 PM
Hi All,
So for some reason i used to be able to use =COUNTIF() formula to compare 2 lots of data and count the number of times it matches.
For some reason and i really dont have a clue why i keep getting the #SPILL error instead?
I've tried Googling it and i cant seem to find the exact fix for this issue
do any of you gurus out there know a fix?
please let me know if i need to clarify anymore information in order for you to help!
Thank you!
Lewis
Apr 21 2021 01:07 PM
The #SPILL error occurs when the spill range for a spilled array formula is not blank.
Apr 21 2021 01:18 PM