Forum Discussion

Copper Contributor

Mar 23, 2022

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 ...

excel

HansVogelaar
Mar 23, 2022
nikunjraval

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.

Source: Number the Visible Rows in Excel AutoFilter

Martin_Weiss

Bronze Contributor

Mar 23, 2022

Hi nikunjraval

the problem is not really clear to me. Could you maybe upload an example file, so we could look into it?

nikunjraval

Copper Contributor

Mar 23, 2022

Martin_Weiss I attached the file

Example.xlsx15 KB

HansVogelaar
MVP
Mar 23, 2022
nikunjraval

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.

Source: Number the Visible Rows in Excel AutoFilter
- nikunjraval
  Copper Contributor
  Mar 24, 2022
  Now it is working. Thank You so much