Log In
Register
Home
January 12, 2023
Offline
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?
See Answer
October 17, 2018
Offline
Please reattach the file as a real attachment cannot download it as you have done now
VIP
Trusted Members
December 7, 2016
Offline
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
Offline
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
Offline
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
January 12, 2023
Offline
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.
VIP
Trusted Members
December 7, 2016
Offline
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
Answers Post
1 Guest(s)
