4 Replies Latest reply on Mar 3, 2016 10:26 AM by Tim Powers

    Filter a range of data (not Top/Bottom N)

    Tim Powers

      Hi,

       

      Would someone be able to help with creating a filtering system that allows me to choose the 1) the row number and 2) input an integer value representing the number of rows to display?

       

      I'd like to be able to display, from a source with 1,000 records or so, the 20-30 records. So I'd like to be able to input into one filter, row '20', and in another one the number '10' so that records 20-30 are displayed,

       

      I've been trying to create something that calculates from INDEX() but am having difficulty getting this right.

       

      Any help is appreciated.

       

      Thanks.