Forum Discussion

Copper Contributor

Jul 31, 2020

The filter function is not applied to all rows

Hi, I could find previous posts with this problem, but the filter function is not being applied to all rows of a sheet. It is formatted as a table which include the "un-filterable" rows, but that...

excel

Formulas and Functions

NikolinoDE

Gold Contributor

Jul 31, 2020

If you could send a worksheet with the problem (without sensitive data), it would be an advantage ... for you and for all who would like to help solve your problem.

thank you
Nikolino
I know I don't know anything (Socrates)

DanielFernandez
Copper Contributor
Sep 07, 2020
Thanks for your interest.
I had incorrectly defined the range of the table in the formula....