7 Replies Latest reply: Feb 27, 2014 11:50 AM by Lorenzo Biancofiore RSS

    Automatic filter on sheet select

      Hi,

      i want to create an automatic filter on sheet activating that select only the Top 10 items of a list.

      The ranking formula is the following:

       

      =aggr(if(rank(sum(value))<=10,State),State)

       

      How can i realize it?