This is my sample input excel.
In excel if we are getting any other words other than highlighted words (refer, Control, list, Vision) that particular cell should be written as blank.
Expected output.
ColB.Equals("refer") and ColB.Equals("vision") and ColB.Equals("control") or ColC.Equals("refer") and ColC.Equals("vision") and ColC.Equals("control") or ColD.Equals("refer") and ColD.Equals("vision") and ColD.Equals("control")
@THIRU_NANI ,
ColB.Equals(“refer”) or ColB.Equals(“vision”) or ColB.Equals(“control”) and ColC.Equals(“refer”) or ColC.Equals(“vision”) or ColC.Equals(“control”) and ColD.Equals(“refer”) or ColD.Equals(“vision”) or ColD.Equals(“control”)
above if condition,
showing output like this.
ColB.Equals(“refer”) and ColB.Equals(“vision”) and ColB.Equals(“control”) or ColC.Equals(“refer”) and ColC.Equals(“vision”) and ColC.Equals(“control”) or ColD.Equals(“refer”) and ColD.Equals(“vision”) and ColD.Equals(“control”)
for this condition,
The output is same as input