29 Mar
2022
29 Mar
'22
2:16 p.m.
On Tue, Mar 29, 2022 at 11:39:34AM +0100, Phil Thane wrote:
I have two loads of data in .ods or .cvs. Basically two versions of a membership list, one with >500 rows, the other >700. I want a list of approx 200 who are on the big list but not the smaller. 'Compare' in LO just gives me a list of thousands of cells that are different, that's no help.
Can you normalise the list of names to some kind of a standard format from the 2 lists? If you can, just export them as plain text, merge the two lists and run them through sort and uniq.
Adam --