Hello Group
mY data is laid out as follows:
A B C D
1 1 20 35 44
2 1 15 23 36
3 1 10 8 16
4 2 35 26 26
5 2 27 14 55
6 2 14 68 35
7 3 5 19 5
8 3 4 58 35
9 3 25 13 53
10

in D11:D13 i am using this formula SUMPRODUCT(MAX((A1:A9=A11)*(D2:D11)))
What do i need to use in B11:C13 to return the corresponding values for the
max line.
so A11:D13 would look like this:

11 1 20 35 44
12 2 27 14 55
13 3 25 13 53

Thanks in advance!