Indentify Duplicates In Table Based On X Columns

I have a worksheet that contains thousands of patient appointment entries, there are more than one entry with the same patient details contained in the worksheet. For example; sometimes a patient will reschedule a appointment, this causes another entry to added for the new appointment. When the patient attends this appointment, the appointment status changes to Seen. But the original entry still stays Rescheduled. This there a way that we can look for identical infomation in some selected columns that match the original entry but have different infomation in some other columns:

E.G. The cells in columns A,B,C,H have identical infomation than the original entry but the cell text in column D equals to "Checked" or "Cancelled" and the cell date in column G is higher than the original entry date. If the result is true then tag the original entry as Invalid