On 29/03/2022 11:39, 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.
OK,
[Insert the usual comments about not using spreadsheets, it's the wrong tool, use a database etc etc etc.]
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.
1) Make a backup of everything, just in case.
New spreadsheet, copy the names from one spreadsheet into 1st Column. Copy names from the other spreadsheet into 2nd column. Select the whole of the two columns. Use Custom Formatting. Look for the Highlight Duplicate Values section, and colourise them.
Then BINGO! All your duplicates are highlighted. Then you can see what matches, and what doesn't.
That may get you part of the way to where you want to be.
Here's an writeup for Excel. There are others: https://theexcelclub.com/ultimate-guide-compare-two-lists-or-datasets-in-exc...
Hope that helps.
Steve