Skip to main content

hi there,

I need to eliminate the below column which i Marked in attached screen shot. i'm attaching the work book as well.What ever the Name occurred or appeared in Occurrence Column  the same name should be populated on restoration as well.  i have tried but it was unsuccessful.Can some one help me.

Thanks in advance.

답변 3개
  1. 2019년 9월 6일 오후 5:22

    Suresh,

     

    You can try

    TRIM( LEFT( [Occurance], LEN( [Occurance] )-9 ) ) = TRIM( LEFT( [Restoration], LEN( [Restoration] )-11 ) )

    and keep the True values.

     

    Michel

0/9000