• 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.

Need to Copy not matched text to New Column

J

jawaharprm

Member
Hi All,
i need to copy not matched text other cell, i attached sample data to understand, Pls help on same.

Jawahar
 

Attachments

  • File.xlsx
    9.5 KB · Views: 5
Power Query solution at cell F1 in attached.
Differences:
Cell G5 has removed both matching Dede.Hickmans
G6 has more results than yours.
 

Attachments

  • Chandoo57694File-1.xlsx
    18.6 KB · Views: 6
You must log in or register to reply here.
Back
Top