• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help...If statement along with Match function

D

Dinesh_Excel

Member
Hi Friends,

Need your help for resolving the below with the below condition.

Appreciate your help on the same.Attached sample for your reference.


  1. Put filters in column “G2” field, and select only fields containing WG1,WG2,WG3,WG4,WG5,WG6 except WG7, WG1_BDF, WG4_MDM and then from a range “AK” it should match any incident in column “A” incidents and then Print it in column AA as “Scope”


  2. Then put filters in the “H2” field and remove those having BDF, SEAL and MDM ( Master data management), VDM ,Vendor data management, Seeburger and then Print it in column AA as “Scope”



  3. In K2 field, exclude those containing words like “authorization” and then Print it in column AA as “Scope”.
Rest blanks in column “AA” should be taken as “Not in Scope”
 

Attachments

  • sample-v1.xlsx
    485.5 KB · Views: 9
You must log in or register to reply here.
Back
Top