8 Replies Latest reply: Mar 29, 2017 12:02 PM by Andrea Giacomello RSS

    Filter sheet using a table column - variable

    Andrea Giacomello

      Hi experts!

      i have this problem regarding filtering my sheet.

       

      I have a table with 5 column:

      1. rowno(total)
      2. Date
      3. text...
      4. text...
      5. text...

      The table is sorted by date, and i would like to filter all the sheet depending on the LAST 100 values of this table (therefore i cannot take a data range picker, because i want the last 100 rows, and dates arenot perfectly distributed). That's why I added the rowno(total) colummn, but I don't know what to do now.

      I thought to a button that set a variable like (rowno<100) but i have no clue how to do that.

       

      Experts! Could you please help me?

       

      Thank you!