Find new addresses, retired and existing

[Olamum]

Hello Everyone,

I have a request regarding obtaining new addresses by utilizing two tables: one containing the existing list and the other comprising the updated list provided by the vendor. The objective is to compare these lists in order to identify:

1. Addresses that are present in both the existing and updated lists (considered as existing).
2. Addresses in the updated list that are not found in the existing list (considered as new addresses).
3. Addresses in the existing list that are not present in the updated list (considered as retired and should be removed).

The updated list encompasses both new and existing addresses.

Thanks All!

Find the link below.

https://docs.google.com/spreadsheets/d/1J13bHevZ_to7aLxLm0S9beSqRoQFeeZG/edit?usp=sharing&ouid=11513...

[Olamum]

@Ashish_Mathur  Please help 

[Ashish_Mathur · Accepted solution]

Hi,

Try the various types of Joins in Power Query.  There are ample Youtube videos you can watch on understanding these joins.  DIY.

[Olamum]

Thanks for your help very much

[Ashish_Mathur]

You are welcome.