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 answers
Suresh,
You can try
TRIM( LEFT( [Occurance], LEN( [Occurance] )-9 ) ) = TRIM( LEFT( [Restoration], LEN( [Restoration] )-11 ) )
and keep the True values.
Michel
