Can you send the file to me?

If not then did you try with
=INDIRECT("B" &
(MATCH(MAX(IF($A$2:$A$100=D2,$C$2:$C$100)),IF($A$2 :$A$100=D2,$C$2:$C$100),1)))


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Andrea" wrote:

I posted no not helpful in error.
I have been able to get the min and max as indicated in the formulas but the
corresponding initials being correctly relayed.
Can you help with this?

"Sheeloo" wrote:

Step 1
I meant headings in ROW 1
Step 4
Could be simplified to
=INDIRECT("B" & (MATCH(E2,IF($A$2:$A$100=D2,$C$2:$C$100),1)))