"MaxIF" or "RankIf" formulas?

[BAMF]

Is there a formula to find the highest score(s) for Bob in a list with all of his games, and all of his teammates games? Something like "MaxIf" would be perfect, but I don't think it exists. It seems logical, but I'm stumped.

If that is possible, can it be taken a step farther to have a formula rank Bob's score (e.g. 1, for his highest score, 2 for his second best score, etc)? Something like "RankIf" comes to mind, but I don't see that either.

I appreciate any help you might be able to provide!

Thank you,
Rich

 

[AhoyNC]

There is a MAXIFS function in Excel 2016 and Office 365.

You could try the array formula below.
This formula must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D	E
1	Name	Score		Name	Bob
2	Sam	55		Score Rank
3	Bob	67		1	82
4	Mary	58		2	67
5	Sam	79		3	65
6	Bob	65
7	Sue	48
8	Bob	82
Sheet