I have a spreadsheet filled with the following:

Column A: Patient ID
Column B: Last Name
Column C: First Name
Column D: Event Date

Many patients have had multiple appointments. I am trying to determine the last appointment for each patient. Please help. I should add that I am a novice and do not speak VBA language. Thank you.