Advanced filter

    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

  • royUK

    Changed the title of the thread from “Advanced filer ?” to “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.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login