Forum Discussion
nikunjraval
Mar 23, 2022Copper Contributor
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 ...
- Mar 23, 2022
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.
nikunjraval
Mar 23, 2022Copper Contributor
Martin_Weiss I attached the file
HansVogelaar
Mar 23, 2022MVP
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.
- nikunjravalMar 24, 2022Copper ContributorNow it is working. Thank You so much