This is brilliant, exactly what I am looking for. I was able to perfectly follow your login until we got to 2b. (I have some troubles with loops so just bare with me)

If I understand it correctly, here is how you did it.

First in 2a, you found the max value from E2-E21 and stored that as MxE

in 2b, you created a loop called Cnt, which will run from FstMtch (in this case 2), until FstMtch+(Mtchs-1) [in this case 21].

for each loop, you added an If statement,

If the Range E & Cnt = MxE (in our case it is 3) and D & Cnt < MnD (which was origanlly set as 99999) then update MnD with the value which is currenly in D & cnt..

then the loop repeats itself until it is over.

I had to write it out in order to fully understand the loop, this is great. I really appreciate your help and your explanation. I should be able to use this and get the values for the rest of the players as well.

Thanks again.

You also mentioned that there is a way to auto update when the values are adjusted, are you able to help me with that, if not it's not necessary, this will do perfectly fine.