Please help... I have two sheets in my workbook. On has a column of names and a column of patient ID numbers. The names are the nurses and the numbers are the patient ID numbers they are assigned to visit (they have been changed for privacy). The other sheet has 4 columns. Column A has the name of the nurse who actually made the visit, column 2 is the corresponding ID number, column C is the visit code and column D is the date the visit was made. I am trying to compare the patient ID number assigned to staff to the pateint ID and staff name who made the visit. The actual report has hundreds of entries... I have a sample spreadsheet but cant see a way to upload the file... Thank you for any help! Kelly
Find latest posts