Hi p45cal,
I have Excel 2016.
I need to find out who applied for overlapping leave so will need to search by names.
What I was hoping for was the function that I could write in column E that would return either "overlap" or "do not overlap" (or "false", "true"...). The return would be for the same person mentioned again somewhere down the lines. Then I could filter the table based on column E and A (Name).
I'm not sure what you did in the table you posted but, I may have few hundreds lines on each report and won't be able to manually search through them.