Hello,

I am trying to filter data from one sheet to another in Excel. I want the range for the formula to include whole columns as I want it to be a living filter. This in the past has resulted in a 0 at the bottom right of the array due to the blank cells it’s trying to  which I have been okay with and ignored. 

This time, however, it’s populating the other cells in that last row with the 0, with duplicate info from further up the array. I have tried several things to get rid of this, including nesting the filter function in a unique function, for changing the way the filter acts towards blank cells, and nothing has resulted in getting rid of the unwanted row. 

Any suggestions?

​Hello, I am trying to filter data from one sheet to another in Excel. I want the range for the formula to include whole columns as I want it to be a living filter. This in the past has resulted in a 0 at the bottom right of the array due to the blank cells it’s trying to  which I have been okay with and ignored.  This time, however, it’s populating the other cells in that last row with the 0, with duplicate info from further up the array. I have tried several things to get rid of this, including nesting the filter function in a unique function, for changing the way the filter acts towards blank cells, and nothing has resulted in getting rid of the unwanted row.  Any suggestions?  Read More

​