Do you mind doing it in R rather than Excel or Access?
If that's ok, something like this
I don't know just what your strings look like but say they are like
this:
L2<-c("apples","pears","bananas","Liverpool","Manchester")
L1<-c("Bob","John","bananas")
mtc<-match(L2,L1)
wh<-which(is.na(mtc))
L3<-L2[wh]
L3
Greg
On 10/04/2024 17:23, John Bibby wrote:
> Can anyone help me please?
>
> I have two lists of text-strings, L1 and L2.
>
> I want to create L3 which contains all members of L2 that are NOT in
> L1.
>
> Thanks for any ideas
> JOHN BIBBY ******************************************************
> Please note that if you press the 'Reply' button your message will go
> only to the sender of this message. If you want to reply to the whole
> list, use your mailer's 'Reply-to-All' button to send your message
> automatically to [log in to unmask] Disclaimer: The messages
> sent to this list are the views of the sender and cannot be assumed to
> be representative of the range of views held by subscribers to the
> Radical Statistics Group. To find out more about Radical Statistics
> and its aims and activities and read current and past issues of our
> newsletter you are invited to visit our web site www.radstats.org.uk.
> *******************************************************
******************************************************
Please note that if you press the 'Reply' button your
message will go only to the sender of this message.
If you want to reply to the whole list, use your mailer's
'Reply-to-All' button to send your message automatically
to [log in to unmask]
Disclaimer: The messages sent to this list are the views of the sender and cannot be assumed to be representative of the range of views held by subscribers to the Radical Statistics Group. To find out more about Radical Statistics and its aims and activities and read current and past issues of our newsletter you are invited to visit our web site www.radstats.org.uk.
*******************************************************
|