Hello,
I'm facing a problem which I couldn't solve even after a long search and trying.
I have a column A, here are date values without gaps. Then I have a column B with dates which are however incomplete, even if there are double values. In column C&D are values that belong to the respective cells in B. I'm looking for a function/macro which
- Compares values from column B with values from column A, if they are the same, puts them next to each other, if there are double dates then delete the doubles and there should be an "X" where the dates should be missing.
I hope that someone can help me. I attached an Example Sorry for my bad English..
Thank you in advance and best regards
Example.PNG
Bookmarks