Spreadsheet help: compare two lists to find exceptions

[DaveC426913]

Maybe you can just write the full column range by default?

Yeah. I just set it to A$1:A$500, which will cover the largest list I have.

But this really gets into the weeds of how I'm going to move forward with this. If this whole process has to survive me (which I verified is the desire, I'm going to have to use the client's preferred software, which is Excel.

Still, no idea where it's going to live or who will be the keeper of the lore. There's no "owner" and no central repository. But that's not an issue that will be solved here...

 

[pbuk]

But this really gets into the weeds of how I'm going to move forward with this. If this whole process has to survive me (which I verified is the desire, I'm going to have to use the client's preferred software, which is Excel.

Oh I have misunderstood, I didn't realise you were being paid for this - my bill is in the post.

 

[DaveC426913]

Oh I have misunderstood, I didn't realise you were being paid for this - my bill is in the post.

It is technically for my (salaried) job, but I don't get expenses. I'm just expected to produce this report.

 

[DaveC426913]

OK, I've switched to Excel. I've got a primitive solution but since it uses the MATCH function, it spits out matches. Any matched records display as #N/A.

What I'm after is the opposite. I need to display non matches.

I've looked at VLOOKUP and HLOOKUP but that's not what I'm trying to do - at least they don't seem to work across two sheets.)

So:

Sheet "RCP":

7072	Alice
4154	Andy
etc.

Sheet "PSS":

7033	Bill
7058	Dave
7072	Alice
7103	Charlie
7113	Annie
etc.

I hope to get:

RCP NO matches in PSS:
4154 Andy

PSS NO matches in RCP:
7033 Bill
7058 Dave
7103 Charlie
7113 Annie

 

[BWV]

With 16K ids on the list, upload each list as a separate table into MS Access and do an outer join

 

[DaveC426913]

With 16K ids on the list, upload each list as a separate table into MS Access and do an outer join

I found an even better solution:
conscript a gaggle of interns to do it with pencil and paper.

 

[BWV]

I found an even better solution:
conscript a gaggle of interns to do it with pencil and paper.

Well you could use the query to check the work, than fire the lot of them for wasting time doing it manually and not knowing how to do a simple query