I have two spreadsheets: one with information about patients' prescriptions and the other about patients' diagnoses. I want to find the matches from one list to the next - in other words, how can I find the patients in the diagnosis spreadsheet who also have a prescription, listed in the other spreadsheet? There are matching patients between these lists and I want to pull out the ones that have both the diagnosis and the prescription. I have tried conditional formatting with highlighting duplicates (too much data and repeat info because there are multiple fill dates for one patient, for example) and conditional formatting with the highlight function using a match formula (conditional formatting > new rule > use a formula to determine which cells to format > match($A2, $1$2:$I$350,0). The latter formula works mostly well, but will not highlight all of the matches (no idea why...). Any help would be very much appreciated...!!
Bookmarks