Remove oldest date in triplicates

[rosafranco2020]

I need help with an excel spreadsheet where I have triplicates (same SSN) that has 3 dates. I need the newest and the second to the newest (to/from) dates only and eliminate the oldest (to/from) date from the spreadsheet. Help!!

 

[GraH]

This seems to work?

Book1
	A	B	C	D	E	F	G	H
1	SSN	From	End			SSN	From	End
2	123344567	1/02/2019	31/08/2020			123344567	6/01/2016	1/01/2019
3	123344567	6/01/2016	1/01/2019			123344567	1/02/2019	31/08/2020
4	123344567	9/01/2020	21/12/2039
Sheet1

Cell Formulas
Range	Formula
F2:H4	F2	=IFERROR(INDEX(A2:C4,ROW(A2:A4)*(RANK.EQ(C2:C4,C2:C4,1)>1),{1,2,3}),"")
Dynamic array formulas.

 

[rosafranco2020]

Thank you so much! You are brilliant!

 

[GraH]

You are welcome. I'm not, but thanks for the kind feedback.