Good Day All
I am creating a spreadsheet to track various training programs, and trying to devise a method to identify if any resource conflicts arise.
I have a Resource name in column E, training start date and end date in columns G & H respectively. I have been trying to set up a formula to check the resource name for duplicates (column E) and if there are any found then verify that the corresponding start and end dates do not conflict. If there is a conflict then output to Column I "Possible Conflict" otherwise jsut leave it blank.
I have been having great difficulties getting my head around this formula and any help would be much appreciated.
Kallee
I am creating a spreadsheet to track various training programs, and trying to devise a method to identify if any resource conflicts arise.
I have a Resource name in column E, training start date and end date in columns G & H respectively. I have been trying to set up a formula to check the resource name for duplicates (column E) and if there are any found then verify that the corresponding start and end dates do not conflict. If there is a conflict then output to Column I "Possible Conflict" otherwise jsut leave it blank.
I have been having great difficulties getting my head around this formula and any help would be much appreciated.
Kallee