Client List with most recent contact

[FormulHuh]

Hi, I am having trouble with INDEX and MATCH, I have an appointments "all appointments" report from a CRM that I am trying to determine last contact date. I have already created the new table and created a unique member ID list but I'm stuck on the formula for identifying most recent attended appointment. I have the following data:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1234[/TD]
[TD]01/06/2018[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1234[/TD]
[TD]20/05/2018[/TD]
[TD]Failed to attend[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1234[/TD]
[TD]01/05/2018[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3456[/TD]
[TD]02/05/2018[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]3456[/TD]
[TD]02/06/2018[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]3456[/TD]
[TD]02/03/2018[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7890[/TD]
[TD]03/03/2018[/TD]
[TD]Failed to Attend[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]7890[/TD]
[TD]03/04/2018[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]7890[/TD]
[TD]03/05/2018[/TD]
[TD]Failed to attend[/TD]
[/TR]
</tbody>[/TABLE]

I Have a new table and I have used the following formula to determine unique ID Numbers:
=IFERROR(INDEX($A$1:$A$33,MATCH(0,INDEX(COUNTIF($F$1:F2,$A$1:$A$33),),0)),"")

Where I am having trouble is using Index and Match to try and calculate the nearest "Attended" appointment to Today().

Any help will be greatly appreciated.
Mike

 

[AhoyNC]

This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed.

Excel Workbook
	A	B	C
1	1234	6/1/2018	Attended
2	1234	5/20/2018	Failed to attend
3	1234	5/1/2018	Attended
4	3456	5/2/2018	Attended
5	3456	6/2/2018	Attended
6	3456	3/2/2018	Attended
7	7890	3/3/2018	Failed to Attend
8	7890	4/3/2018	Attended
9	7890	5/3/2018	Failed to attend
10
11
12	1234	6/1/2018
13	3456	6/2/2018
14	7890	4/3/2018
Sheet