Hi All,
I am looking to hide the filter arrow in the top row of a filter range by use of the advanced filter.
Does anyone know what I need to enter as the formula to filter values less than 0 (<0)
or, is there a way to do this by VBA?
Thanks
Hi All,
I am looking to hide the filter arrow in the top row of a filter range by use of the advanced filter.
Does anyone know what I need to enter as the formula to filter values less than 0 (<0)
or, is there a way to do this by VBA?
Thanks
When you click the arrow you see a menu. Select the Number Filters option and use<0.
Note this is AutoFilter not Advanced Filter
For the advanced filter, you could enter the relevant header text in one cell, and <0 in the cell below and then use those two cells as the criteria range.
Don’t have an account yet? Register yourself now and be a part of our community!