varvoura
asked on
3 lists comparison
Hi all,
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
Varvoura
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
Varvoura
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
two stage check??
Are you saying the @replace twice? with list1, list2 and then the resulted field with list3?
I'll attempt anyway, but I'd need further clarification to this.
Thanks
Are you saying the @replace twice? with list1, list2 and then the resulted field with list3?
I'll attempt anyway, but I'd need further clarification to this.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks sjef, I'll try that today but somehow I know it will work fine with no problems.
Thanks for your help
Thanks for your help
Trying won't offend me, since I never tested it. What's more important, assuming it works: try to unravel it, why does it work?
Steve