Link to home
Start Free TrialLog in
Avatar of varvoura
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
SOLUTION
Avatar of Steve Knight
Steve Knight
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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 :-)


Steve
Avatar of varvoura
varvoura

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

ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks sjef, I'll try that today but somehow I know it will work fine with no problems.

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?