string comparison of columns

[anjali0108]

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.

[Peter_Cammaert]

No problem. I got it. See the solution(s) below.

[anjali0108]

Hey kamal,

Thanks for your time.

I missed on one thing, I need the output in straight table not in list boxes.

and when I am adding all in one table ,it is creating duplicates that I was mentioning earlier.

Please look at the sample output table that I have added above.

Thanks.

[kamal_sanguri]

Here it is...

[kamal_sanguri]

And to answer your question, when you include multiple fields from non linked table in a table. It works like a cross join, hence you will see every item from List1 would have every corresponding item from List1.

[kamal_sanguri]

Also, you can easily remove the first dimension List (you might not require it). I just added it show all the servers in all the list.

[anjali0108]

Hi Peter,

Thanks a lot.I got the output as expected.

In addition, I have to add columns B and C in the table as well but that I will figure out.

Thank u soooooooooooooooooooooo much