Look for Max and second Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top