Excel spill

Copper Contributor

While using a filter function, the information I have is spilling down as it should. What I want to know is if there is a way for the spill to fill 20 cells, stop for 4 cells and continue a spill. If that makes sense? 

1 Reply

@iAmTheRedOne 

 

Does it make sense?

 

Yes. And No.

 

It's intelligible, what you're describing. Whether or not it makes sense, however, to expect Excel's dynamic array functions to perform that way, well, that's another story. I don't think it can, but I'm willing to be corrected if someone with more experience can show us how.

 

Are you aware of the WRAPCOLS function == depending on whether your FILTER is producing a single column or not, and what your goal here is (page breaks, for example), the WRAPCOLS function, with FILTER nested within it, might deliver the desired result.