Forum Discussion
Solved
There is a problem with the filter when I apply the formula
When I add the formula and then apply the filter, the last row comes automatically.
When I applied this formula in Google Sheets it is working very well there
Currently, I am using Microsoft Office Home and Student Copy 2019
Please help
This is a known problem caused by the SUBTOTAL formula.
Solution: change the formula in B3 to =--SUBTOTAL(3,$D$3:D3) and fill down.
4 Replies
Hi nikunjraval
the problem is not really clear to me. Could you maybe upload an example file, so we could look into it?
Martin_Weiss I attached the file
This is a known problem caused by the SUBTOTAL formula.
Solution: change the formula in B3 to =--SUBTOTAL(3,$D$3:D3) and fill down.
