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

Who is Participating?

Improve company productivity with a Business Account.Sign Up

Sjef BosmanConnect With a Mentor Groupware ConsultantCommented:
@Trim(@Replace(@Trim(@Replace(list1; @Trim(@Replace(list1; list2; "")); "")); list3; ""))
Steve KnightConnect With a Mentor IT ConsultancyCommented:
Combine List1 and list2 with @Unique(List1:List2) then use the same formulas as before.

Steve KnightIT ConsultancyCommented:
And reading again ... I'm clearly talking rubbish.  A two stage check of list1 with 2 then the result with 3 should work, haven't got Notes at the moment to try it and off now anyway, no doubt someone else will be along shortly :-)

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

varvouraAuthor Commented:
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.


varvouraAuthor Commented:
thanks sjef, I'll try that today but somehow I know it will work fine with no problems.

Thanks for your help
Sjef BosmanGroupware ConsultantCommented:
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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.