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?
Please reattach the file as a real attachment cannot download it as you have done now
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
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.
Hello,
You didn't complete all the steps in Power Query.
See attached file for the finished version. There are two dates in column A that also exists in column C, those are removed.
Br,
Anders
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.
Hello,
Well, if you are using an old version of Excel it might be that Power Query is not the right tool.
Attached is a variant where I use a helper column to get the dates list in a pivot table.
Br,
Anders
Thank you so much on your nice work indeed Anders.
Good man!
