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