Is there a method (the easier the better) with Numbers 10.3.5 and running OS X (Big Sur) on a MacBook Pro of comparing the contents of 2 or more Numbers spreadsheets to effect one remaining spreadsheet with no duplicates but containing all the data from both spreadsheets?
Thank you.
MacBook Pro 16″, macOS 11.1
In Numbers a spreadsheet is an entire document. And sheets in Numbers, unlike in Excel, don't have cells arranged in rows and columns. So I'm guessing you mean you want to compare two tables?
What do the tables look like? Perhaps you could post a screenshot to clarify your problem.
My general approach to a problem like this is usually to paste all the data into one table, then use Categories to eliminate the duplicates (without having to write and debug formulas). But the best solution in your case will depend on what you have to work with.
SG
I'd prefer not to copy and paste as the 2 spreadsheets have confidential data. However, I can describe them. Each of the 2 spreadsheets has a number of columns and rows. In the first column are names of organizations. In the second column are identification numbers. In the third column are passwords.
How might the contents of the columns be compared across 2 spreadsheets?
Thank you.
How to compare two Numbers 10.3.5 spreadsheets?
