Forum Discussion
Excel Array Problem
I have a formula that checks another array to see if a cell is empty before running however this is spilling past where I am telling it to check and displaying a #N/A error. How do I get it to stop s...
It's not clear what you'd try to do with
=IF(T4#="","",...
If in T4 is returned the array with no elements (empty array), Excel shall to show #CALC error in T4 since empty arrays are not supported.
If in T4# is an array with empty texts ("") above works if only you have only one element in such array.
If more than one, what we'd like to check - if all elements are empty, or some, or first element only, etc.