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 spilling past the rows I am asking in the T4# array. Here is the formula.
=IF(T4#="","",SORTBY(CHOOSECOLS(FILTER(TBLData,TBLData[Date]=L3),1,3),TestSort,-1))
5 Replies
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.
It would be much easier to help you if you had uploaded a sample file. Please do so so that we can see the data layout and what is what. From what I can see there is 100% a dimension problem. You are trying to input "" when a cell in T4# array is empty and 2 values from the sortby(...) function when it is not.
It is saying the xlsx file is not supported when trying to upload it. Any suggestions?Maciej_Kopczynski
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
