Working on an excel problem any help would be appreciated. I have two excel workbooks. WorkbookA and WorkbookB both of them have one spreadsheet with similar data. 1st requirement is to merge them group by patient ID and Event Name and 2nd requirement is to find the difference if its there in each cell and highlight it. Please find the attachment for additional information. I have them all in one excel workbook.
Thanks in advance.