I have 7K records with duplicate entries. I think I have found the two dates where there are duplicate entries. I need a formula that will count how many times '2016-11-10' for instance, is in each cell and highlight the cell if the date appears more than once in that cell. Any takers?


2017-04-05 xXnie X Xe x X Xonti: Sent xXvis TrXnsfer XebinXr Invite. -2017-03-03 xXnie X Xe x X Xonti: Sent xXvis TrXnsfer XebinXr Invite. -2017-03-02 xXnie X Xe x X Xonti: Sent xXvis TrXnsfer XebinXr Invite. -2017-02-23 xXnie X Xe x X Xonti: Sent xXvis TrXnsfer XebinXr Invite. -2017-02-23 xXnie X Xe x X Xonti: Sent xXvis TrXnsfer XebinXr Invite. -2017-02-23 xXnie X Xe x X Xonti: Sent xXvis TrXnsfer XebinXr Invite. -2016-11-10 : Sent xXvis TrXnsfer XebinXr Invite 2016-11-10 : Sent xXvis TrXnsfer XebinXr Invite 2016-11-10 : Sent xXvis TrXnsfer XebinXr Invite 2016-11-10 : Sent xXvis TrXnsfer XebinXr Invite 2016-11-10 : Sent xXvis TrXnsfer XebinXr Invite