fa2020
09-05-2020, 09:49 AM
Hi,
The same thread has been posted in this address:
https://www.excelforum.com/excel-programming-vba-macros/1326465-detecting-date-errors.html
I tried to simplify it in an another example.
I have an excel file containing thousands of rows. There are ID, Planned Start End Date, and End Date columns.
All IDs needs to have at least one same Planned Start End Date and End Date (equal C and D columns). If an ID doesn't have at least one equal Planned Start End Date and End Date, write them in another cell.
My desired answer is something like this (The answer is at the right side):
27071
Please help me out. :crying:
Thanks.
The same thread has been posted in this address:
https://www.excelforum.com/excel-programming-vba-macros/1326465-detecting-date-errors.html
I tried to simplify it in an another example.
I have an excel file containing thousands of rows. There are ID, Planned Start End Date, and End Date columns.
All IDs needs to have at least one same Planned Start End Date and End Date (equal C and D columns). If an ID doesn't have at least one equal Planned Start End Date and End Date, write them in another cell.
My desired answer is something like this (The answer is at the right side):
27071
Please help me out. :crying:
Thanks.