30 Mar
2022
30 Mar
'22
8:55 a.m.
On Tue, 29 Mar 2022 at 22:20, steve-ALUG@hst.me.uk wrote:
A quick and dirty solution that you may be able to make work, which I have used very successfully in Excel, and I bet it'll work in Calc.
Another way would be to have the shorter list in column A, the longer list in column B, and a third column that does a VLOOKUP - C1 does a VLOOKUP of B1 in column A, C2 does a VLOOKUP of B2 in col A, etc. That would give you a value against each col B record telling you if it existed in col A, from which you could sort/filter out the ones which didn't have a match.
Mark