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