Combine two list with old and new

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have two spreadsheets: 1st spreadsheet shows client id and client name 2nd spreadsheet shows client Id, client name and client information. Spreadsheet 1 is my list of clients old and new; spreadsheet 2 is my master client list with out the new clients. I want to sort/figure out which items on spreadsheet 1 that are not on spreadsheet 2. I hope this makes since and someone can help me.

Thanks


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
0