S
Sandy
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
13 i am using this formula SUMPRODUCT(MAX((A1:A9=A11)*(D211)))
What do i need to use in B11:C13 to return the corresponding values for the
max line.
so A1113 would look like this:
11 1 20 35 44
12 2 27 14 55
13 3 25 13 53
Thanks in advance!
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
13 i am using this formula SUMPRODUCT(MAX((A1:A9=A11)*(D211)))What do i need to use in B11:C13 to return the corresponding values for the
max line.
so A11
13 would look like this:11 1 20 35 44
12 2 27 14 55
13 3 25 13 53
Thanks in advance!