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
|
|||
|
|||
Look for Max and second Max
Dear expert,
Have made a similar post before. I am looking for the highest and the second high after the first highest. One of the experts replied me In Cell E1 to use =Max(A1:A7) In Cell F1 to use this. =MAX(INDIRECT("A"&MATCH(E1,A1:A7,0)+1&":A7")) But when I add a row .... it does not work. Also, when I move the data and move the function series (though I have modified ":A7" to new address), it does not work either 91.27 (max) in a cell and second high 87.96 (2nd one after the higest is formed) Can I modify the function so that it can display this result? Data in A1 to A7 52.35 26-Jan-10 59.87 18-Feb-10 89.95 26-Feb-10 85.41 05-Mar-10 91.27 10-Mar-10 87.96 23-Mar-10 36.69 29-Mar-10 26.69 01-Apr-10 46.69 09-Apr-10 Thanks Elton |
Thread Tools | |
Display Modes | |
|
|