29 Mar
2022
29 Mar
'22
2:42 p.m.
On Tue, Mar 29, 2022 at 11:39:34AM +0100, Phil Thane wrote:
Database nerds look away now.
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 anyone help? Lots on t'internet about merging and tracking changes but nothing about my case I can find.
I hate to say it but the obvious answer is that the data shouldn't be in a spreadsheet! :-)
Can you export them (via CVS) to two tables in a database, it would then be trivial to get the answer you want.
--
Chris Green