6 Replies Latest reply: Oct 20, 2016 6:46 AM by Sunny Talwar RSS

    How to use Pick and Match for the below

    sundarraj ramchandran

      Hi gysbert wassenaar ,

       

      Can anyone formulate the below with pick and match function .

       

      =if(PG='M'

      or PG='P others'

      or PG='NE'

      or PG='PE'

      or PG='HC'

      or PG='EC'

      or PG='FOOD'

      or PG='BIO'

      or PG='DIS

      or PG='SB'

      or PG='Ca'

      or PG='PH

      or PG='PRO'

      or PG='SEYO',dual('Others',26),

      if(PG='CP',dual('CPS',12),

      if(PG='PC',dual('PCS',10),

      if(PG='VC',dual('VCS',11),

      if(PG='ALL',null(),PG)))))