A FILTER size error means its conditions do not align with the data being filtered. Inspect start rows, end rows, and orientation before changing the condition itself.
Compare the dimensions
If the output range is A2:C100, a row condition such as D2:D100 has matching height. D1:D100 includes an extra header row, while D2:D99 is one record short.
An open-ended data range paired with a short fixed condition can also mismatch. Write down the exact boundaries of every argument rather than judging the highlighted selection by appearance.
Align records as well as lengths
Two equally long ranges can still be offset by one row. Make sure each condition describes the corresponding source record. Do not pad the condition with arbitrary TRUE values merely to make the dimensions agree.
Google requires all conditions in a call to be of the same type: row conditions or column conditions. To filter both dimensions, use an appropriately designed nested operation instead of mixing them within one FILTER call.
Verify results after the error disappears
Test a first-row match, a last-row match, and a record that should be excluded. Check their IDs and the total output count. Successful expansion is not proof that condition rows correspond to the right records.
Keep output cells clear and include new rows consistently across the data and conditions. If the formula is copied, inspect whether relative references shifted only part of the expression. Use deliberate anchors or a maintained source structure so future edits do not recreate the mismatch. Retain the original formula until the repaired result has been reconciled against a small known sample.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.