Unique cells

[dilans]

I have two sheets with a thousand rows. The both sheets are connected to a service that people can buy. The first one contains billing information from the supplier (in other words, the accounts that the supplier charge me for), and the other sheet contains billing information on the people that I currently bill. Hence, there are some unique people that the supplier charge me for and that I don't currently bill. 

How can I easily do to find those unique usernames that exists in the first sheet and not the second one? 

Is there anyway to do this as an automated process since it has to be done regularly?

[#2]

@dilans You could use XLOOKUP to identify names in the first list that do not occur in the second list. Then filter out these names and use UNIQUE to list out only unique names.

Alternatively, if this is something that needs to be repeated frequently you should consider using Power Query (PQ). Connect to each list, merge Left-Anti-join, Remove Duplicates. Are you familiar with PQ?

[#3]

No I am not very familiar with it. But I am a fast learner

[#4]

@dilans This would be a good start.

https://exceloffthegrid.com/power-query-introduction/ 

Attached an overly simplified example.

[#5]

Thanks, I will have a look into it!
However, it does not seem as xlookup and UNIQUE works for my purpose