Get max status based on date

[Wishmaster89]

Hi All

I'd like to get the max status from column B based on the latest start date from column C. So the max status in this example should be as 12/01/2021 is the max start date. I thought i had the answer when i used max ifs in column t but then realised its obviously not taking the start date into account.

Book9
	A	B	C	D	E	F	G	H	I	J	K	L	M							T	U	V	W	X
1	ULN	Completion Status	Start Date	Start Year	Learning_Actual_End_Date converted	Withdrawal time frame(days)	Months	Standard	hybrid end year	Year	Restart indicator	max HEY	hybrid year with max							Max status	MIN Start date	Start year	Max status if 17/18	Max status if 18/19
2	1	1	18/07/2019	2018			not in a category	Maths	17/01/2021	20/21	1	30/11/2021	21/22							6	18/07/2019	18/19		6
3	1	3	12/01/2021	2020	19/07/2021	188	not in a category	Maths	30/11/2021	21/22	1	30/11/2021	21/22							6	18/07/2019	18/19		6
4	1	6	18/07/2019	2018	14/09/2020	424	13-18	Maths	17/01/2021	20/21	1	30/11/2021	21/22							6	18/07/2019	18/19		6
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	Cell Value	duplicates	text	NO
A1:A1043475	Cell Value	duplicates	text	NO

 

[Wishmaster89]

Ok, how about

=INDEX(SORT(FILTER($B$2:$C$5000,($A$2:$A$5000=A2)*($H$2:$H$5000=H2)),{2,1},-1),1,1)

That works! Thank you so much.

 

[Fluff]

Glad to help & thanks for the feedback.