Excel Array Problem

[gvera1855]

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))

[#2]

@gvera1855 

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?

[#3]

@gvera1855 

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.

[#4]

It is saying the xlsx file is not supported when trying to upload it. Any suggestions?@Maciej_Kopczynski 

[#5]

@gvera1855 

Post a shared link to your sample workbook with the expected result.

[#6]

@gvera1855 

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.