

January 12, 2023

Hello again. I have another problem.
I have a set of dates in Column A, another set of dates in Column B, I want to compare this two column of dates, so that if any dates exists in Column B, it will not copy in Column C. So Column C basically are the dates from Column A, just that if any of the dates appear in both Column A and B, it will not show in Column C.
I try to use a vba to do it, but it didn't do the job. I attached my works for your information.
Any thoughts?

VIP

Trusted Members

December 7, 2016

Hello,
Take a look at the Excel compare two lists blog post, it describes how to use Power Query to compare two lists.
Br,
Anders


January 12, 2023

Hello Anders, no joy, I try to use power query in my worksheet. But once I merge, all dates in column A still paste to the new column, even the date exists in column B.
Hi Hans, I upload my file again, please right click the link and select "save link as" if you are using chrome.

VIP

Trusted Members

December 7, 2016



January 12, 2023

Thanks Ander, I think is my version of excel. I understand that my previous attachment didn't finish the power query because when I try, the result didn't exclude that 2 days in the new sheet like yours.
When I open yours attachment and try to refresh the query. A warning box show up and said the power query is not compatible with my current version.
Anyway, I guess I know what is going on now.
Thank you very much indeed.
1 Guest(s)
