Solved

3 lists comparison

Posted on 2006-06-17
6
213 Views
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

Varvoura
0
Comment
Question by:varvoura
  • 2
  • 2
  • 2
6 Comments
 
LVL 43

Assisted Solution

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

Steve
0
 
LVL 43

Expert Comment

by:Steve Knight
Comment Utility
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
0
 

Author Comment

by:varvoura
Comment Utility
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

0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 150 total points
Comment Utility
@Trim(@Replace(@Trim(@Replace(list1; @Trim(@Replace(list1; list2; "")); "")); list3; ""))
0
 

Author Comment

by:varvoura
Comment Utility
thanks sjef, I'll try that today but somehow I know it will work fine with no problems.

Thanks for your help
0
 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
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?
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now