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

    Account Names Filtering

    koushik.neelakantha

      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.

       

      Requirement:

       

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

       

      Please help me out.

       

      Regards,

      Koushik.

        • 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

          Index:

          INDEX()

           

          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.