Looking up most recent date, cross references with a title from set of columns

[RoundaboutCJP]

Hi everyone in the Excel-sphere this afternoon.

I have a table of course details:

A	B	C	D	E	F	G	H	I	J	K
Name	1	Date	2	Date	1	Date	1	Date	Date	Date

The numbers 1 and 2 relate to two different training courses and the dates are when people attended them.

I am looking for a formula that will scan those columns and tell me in column J the date of the most recent date that someone attended course 1. And in column K the most recent date that someone attended course 2.

Is that possible? I'm struggle to get it to cross reference matching the course title and the dates properly.

Thanks so much all.

[FDibbins]

You could probably do this with the max(if()) array formula, but to get better advice, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[RoundaboutCJP]

Thanks muchly FDibbins,

Attached.

The question is, what is the formula that goes in the Green cells.

Thanks

[FDibbins]

Try this ARRAY formula...
=MAX(IF($G3:$Q3=B$2,$H3:$R3))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Copy across, then copy down as needed

[RoundaboutCJP]

Brilliant, thank you so so much

[FDibbins]

Happy to help and thanks for the feedback