ExcelBanter - find max..

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - find max.. (https://www.excelbanter.com/excel-worksheet-functions/200411-find-max.html)

find max..

assume we have the following lists...
How can i return max value of "id"?

e.g.
ia1 = 11
ia2 = 8
ia4 = 5
ib1 =7

id month
ia1 2
ia2 3
ia3 4
ia4 5
ia1 5
ia2 6
ib1 7
ib2 8
ib6 9
ia1 11

Teethless mama

find max..

=MAX(INDEX((A2:A11=D2)*B2:B11,))

" wrote:

assume we have the following lists...
How can i return max value of "id"?

e.g.
ia1 = 11
ia2 = 8
ia4 = 5
ib1 =7

id month
ia1 2
ia2 3
ia3 4
ia4 5
ia1 5
ia2 6
ib1 7
ib2 8
ib6 9
ia1 11

All times are GMT +1. The time now is 09:23 AM.