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

    string comparison of columns

    Anjali Ahlawat

      Hi,

       

      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.

       

      Thanks.