F
Freshman
Dear experts,
In a worksheet, column A is for player's name and column B is for player's
scores. I list some examples below:
John 25
Peter 65
May 37
Tim 81
Peter 50
Peter 71
May 68
John 57
In C1 is for a lookup value, D1 is for the MAX value of C1 and E1 is for the
MIN value of C1. So, when I input Peter in C1, then D1 will show 71 and E1
will show 50. In such a case, what should be the formula in D1 and E1? Please
kindly advise.
Thanks in advance.
In a worksheet, column A is for player's name and column B is for player's
scores. I list some examples below:
John 25
Peter 65
May 37
Tim 81
Peter 50
Peter 71
May 68
John 57
In C1 is for a lookup value, D1 is for the MAX value of C1 and E1 is for the
MIN value of C1. So, when I input Peter in C1, then D1 will show 71 and E1
will show 50. In such a case, what should be the formula in D1 and E1? Please
kindly advise.
Thanks in advance.