1 Reply Latest reply on Dec 6, 2016 5:54 AM by Maciek La

    Account Names Filtering


      Hello everyone,


      Please find the attached workbook. I have 50 account names and I need to divide 50 account names in 5 different sheet without going with Filter option.




      Each sheet should have 10 account names so that 50 names will get splitted into 5 work sheets.


      Please help me out.




        • 1. Re: Account Names Filtering
          Maciek La

          Well, you will have to use some kind of filtering anyway if you don't want to split your datasource.

          I believe that you would like to avoid manually filtering emails.


          You can try INDEX() approach. do the calculated  CONTINUOUS field




          and then

          1. add email to the sheet

          2. add index field to the filtering shelf and select 5 points entries for each sheet.

          3. duplicate sheet and change filtering range.