Jun 06 2019 05:14 PM
I inherited a huge file where I have to compare data across multiple columns: i.e. patient name, date of service, etc. The two fields I really need to focus on are the patient's name and the date of service -both columns have to be an exact match to determine if there is a duplicate. Using Conditional Formatting it highlights everything that is a duplicate even if the patient name is not but the date of service is. Is there an easy formula to compare data for patient names in column A and also find any duplicates of the same patient with multiple dates of service? I'm reviewing the file for patients who may have been charged multiple visits on the same date. Any help or guidance is greatly appreciated. Thank you.
Jun 06 2019 05:31 PM
Jun 07 2019 09:48 AM
Thank you -this helped tremendously! @Zack Barresse