15 Replies Latest reply: Jun 12, 2017 8:39 AM by Anjali Ahlawat RSS

    string comparison of columns

    Anjali Ahlawat



      I have server list (let's say A,B,C ) in 3 different columns of different excels which are not at all linked.


      I want to subtract the list of servers (B+C) from A and create one column D.


      I am using the expression (something like),


        if(match(A,B)=0,B) ,it is giving me values but when I am adding all these columns in one table then it is creating duplicates.


      Please let me know what is wrong here.