E
Elton Law
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
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