How do I compare all the fields between two columns and get only the the unique values among them.
I am attaching part of the data.
One column has dates that the second column does not. I have to find out the dates that are not in column 1 and put it in say column C and the dates that are in column B and not in column A put them in column D.
Is there a function which I can use to achieve this result?
Last edited by excelnoobforever; 08-28-2020 at 09:05 AM. Reason: Type
You could use formulas like
In C2: =IF(COUNTIF(B:B,A2)>0,"",A2)
In D2: =IF(COUNTIF(A:A,B2)>0,"",B2)
Then drag them down the column as far as needed.
Last edited by JLGWhiz; 08-28-2020 at 11:38 AM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
What did you try to do in post #2? Looks like the forum can't handle the code.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Fogrot which forum I was posting to. Senility!!Originally Posted by AliGW
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks