If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|