ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula Help (https://www.excelbanter.com/excel-worksheet-functions/83115-formula-help.html)

Sandy

Formula Help
 
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!



All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com