3 lists comparison

Posted on 2006-06-17
Last Modified: 2013-12-18
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

Question by:varvoura
  • 2
  • 2
  • 2
LVL 43

Assisted Solution

by:Steve Knight
Steve Knight earned 100 total points
ID: 16928563
Combine List1 and list2 with @Unique(List1:List2) then use the same formulas as before.

LVL 43

Expert Comment

by:Steve Knight
ID: 16928573
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 :-)


Author Comment

ID: 16928630
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.


Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

LVL 46

Accepted Solution

Sjef Bosman earned 150 total points
ID: 16929733
@Trim(@Replace(@Trim(@Replace(list1; @Trim(@Replace(list1; list2; "")); "")); list3; ""))

Author Comment

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

Thanks for your help
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16932511
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?

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to automate deletion of content in Lotus Notes mailboxes 3 217
VBA Lotus notes 2 198
Domino Server 2 76
Lotus notes - Follow up notes mail missing 15 73
This is an old article, please see an updated version of this article, located here:
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In a recent question ( here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question