Return largest values based on text criteria

[klimax]

racking my brain trying every various combinations of formula, but using the following general setup have the user provide a "name" and a "skill" and have formula return the three most recent dates and corresponding grades.

Biggest problem i have is that the raw data is in the format that the "skills" are bunched together in a single cell per-instance of date.

in this setup, if i was to provide the name "Karen" and the skill of "jumping" i would like it to return....
1(1/5/2018-84) 2(1/4/2018-85) 3(1/3/2018-62)

the more i look at it, the more it seems that i may need to have another set of columns to split up the text in the 'skill(s)' cell, but i am trying to avoid that.

 

[Eric W]

Perhaps:

	A	B	C	D	E	F	G	H
1	Name	Date	Grade	Skill(s)
2	Bob	1/1/2018	70	Running,jumping,sports		Name	Karen
3	Karen	1/1/2018	76	Running,jumping,sports		Skill	Jumping
4	Sally	1/1/2018	79	Running,jumping,sports
5	Bob	1/2/2018	78	Running,jumping,sports
6	Karen	1/2/2018	76	Running,jumping,sports		Most recent grades based on skill
7	Sally	1/2/2018	60	Running,sports		n-th	Date	Score
8	Bob	1/3/2018	62	Running,jumping,sports		1	1/5/2018	84
9	Karen	1/3/2018	62	Running,jumping,sports		2	1/4/2018	85
10	Sally	1/3/2018	67	Running,jumping,sports		3	1/3/2018	62
11	Bob	1/4/2018	83	Running,jumping
12	Karen	1/4/2018	85	Running,jumping
13	Sally	1/4/2018	62	Running,jumping,sports
14	Bob	1/5/2018	94	Running
15	Karen	1/5/2018	84	Running,jumping
16	Sally	1/5/2018	70	Running,Sports

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet4​

Array Formulas Cell Formula G8 {=LARGE(IF($A$2:$A$16=$G$2,IF(ISNUMBER(SEARCH($G$3,$D$2:$D$16)),$B$2:$B$16)),ROWS($G$8:$G8))} H8 {=INDEX($C$2:$C$16,SMALL(IF($A$2:$A$16=$G$2,IF($B$2:$B$16=G8,IF(ISNUMBER(SEARCH($G$3,$D$2:$D$16)),ROW($A$2:$A$16)-ROW($A$2)+1))),COUNTIF($G$8:$G8,G8)))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

The formula in H8 could be a tad simpler, but I allowed for the possibility of multiple scores on the same date.