Forum Discussion
How to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FI...
I agree with the replies you have received to date.
You build the output within a single formula as one spilt range.
Conditional formatting could then be used to highlight the header rows.