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?
Trusted Members
October 17, 2018
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)