Hi there,
I'm Struggling with the below sheet that in the occurrence column it is taking Neutral disturbance- occurrence and in the restoration column it has to take Neutral Disturbance- Restoration but instead of that it is taking earth loading occurrence. Can some one help. I have tried a condition which doesn't worked out. i'm attaching the workbook as well.
5 réponses
Hi Suresh,
From what I understood this is what you wanted. I took all the occurrences from the restoration column using IF CONTAINS([Restoration],"Occurence") THEN 'ok' ELSE 'Eliminate' END
Find the example attached. Hope this helps. If this helps, please mark it as helpful and correct so other users can refer to it. Many thanks!
Best,
Diego
