3 lists comparison
Posted on 2006-06-17
Is there anyway that I can compare three lists in the one formula.
I know that I can use the @replace to compare two lists, but not sure if I can compare three lists.
For example, I want to find out those items which are in the first list and the second list but not in the third list
list1: item1, item2, item3
list2: item1, item4, item 5
list3: item6, item7, item8
Myresultlist should contain: item1
Is this possible?
Any ideas, help is much appreciated