Hi All,
I am trying to compare 2 sets of data, the issue relies on the fact that the dates on DATE_1 (Column A) do not always match those in DATE_2 (Column D), so an additional column (G) has to be built in order to display the common dates in both datasets. I have shown below the info the columns have and manually i have input the result I am looking to get by using a formula or vba.
Any guidance would be greatly appreciated. (I know I can get the DATA1 and DATA2 for the comparison using vlookups) so I am mainly focusing on how to get column G built.
Thanks in advance
macutna
Bookmarks