Hi,

I am trying to write a formula that will pick up duplicate dates for each person in a really, really large worksheet.
I can identify the duplicate dates using the simple conditional formatting but have to select each group of data (the name) in order to da that, with 20 000+ lines of data this takes forever & sometime I might highlight to much data giving me an incorrect duplicates.

Attached is a example of data that I am working with I have highlighted the entries that I am trying to identify.

Any assistance would be very much appreciated.

Thank you in advance.

Data.xlsx