How do I compare two (not identical) tabs (or sheets) for differences in a specific column

user_10912200 0
Viewed 46

I have two database dumps in Google sheets. They contain several thousand entries - many are identical, but not all. I now need to find all of those where a number in a specific column has increased by a certain number. The problem is that the rows not necessarily are the same, as entries in the database can have been deleted - and more been added, so rows do not add up.

I have tried various forms of 'if' and 'query' - none that have brought me closer to a solution.

I'm thinking that I first need to compare the column where the unique id is to ensure that it is the right entry that is being compared.

I would like to completely automate this, but a semi-manual way of doing this could also be okay.

One solution for this could be to get Google to check the unique id's of the two tabs - and then display the content of a second column in the first tab only where the id's can be found in both tabs. I just cannot get Sheets to do this.

Any help would be appreciated

google-sheets
2 Answers

if I understood you right you can use filters for your task. For example

=FILTER(YourSheet1!B$2:B;YourSheet2!A$2:A=C2;YourSheet2!D$2:D=E2)

It will return you the line, where A$2:A == C2 and D$2:D == E2 from sheet two. So you can using filters choose data that has equal column values. If there exist copies it will return an error to the cell

user_109063900

Found the solution... A simple LOOKUP was what I needed:

=LOOKUP(B147,stats23Dec!B:B,stats23Dec!G:G)

user_109122000
Related