Hello
I'm looking to using a combo of index/match and max to find the highest value associated with a name
This is what I have for cell E3, but it seems to be pulling the overall max number:
=INDEX(MAX($B$3:$B$8),MATCH(D3:D7,$A$3:$A$8,0))
Any ideas?
I'm looking to using a combo of index/match and max to find the highest value associated with a name
This is what I have for cell E3, but it seems to be pulling the overall max number:
=INDEX(MAX($B$3:$B$8),MATCH(D3:D7,$A$3:$A$8,0))
Any ideas?