Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear enough.

I'm looking for the min and the second lowest (after the first min is found).
In thie case, I hope I can use function to sort out 24.59 after the lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

Try the SMALL & LARGE functions.


--
Regards
Dave Hawley
www.ozgrid.com
"Elton Law" wrote in message
...
Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear
enough.

I'm looking for the min and the second lowest (after the first min is
found).
In thie case, I hope I can use function to sort out 24.59 after the lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

Hi Ozgrid,
Small and Large cannot solve the sequent issue.
Thanks


"ozgrid.com" wrote:

Try the SMALL & LARGE functions.


--
Regards
Dave Hawley
www.ozgrid.com
"Elton Law" wrote in message
...
Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear
enough.

I'm looking for the min and the second lowest (after the first min is
found).
In thie case, I hope I can use function to sort out 24.59 after the lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

Hi Elton,

Please explain the "sequent issue"


"Elton Law" wrote in message
...
Hi Ozgrid,
Small and Large cannot solve the sequent issue.
Thanks


"ozgrid.com" wrote:

Try the SMALL & LARGE functions.


--
Regards
Dave Hawley
www.ozgrid.com
"Elton Law" wrote in message
...
Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear
enough.

I'm looking for the min and the second lowest (after the first min is
found).
In thie case, I hope I can use function to sort out 24.59 after the
lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

Hi Steve,

In this case, I would to get the lowest (which is very easy) and then get
the second lowest after the lowest is formed in date squenece.
I get the result which are 18.25 on 9 Feb and 24.59 on 1 April 2010.
In theory, the lowest is 18.25 and second min is 21.36 in the series.
But I need the second low after the the first low is done.
So the only second smallest after 18.25 should be 24.59.
21.36 should be ignored. Can any function be done this. thanks indeed for
help. Thanks

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

"Steve Dunn" wrote:

Hi Elton,

Please explain the "sequent issue"


"Elton Law" wrote in message
...
Hi Ozgrid,
Small and Large cannot solve the sequent issue.
Thanks


"ozgrid.com" wrote:

Try the SMALL & LARGE functions.


--
Regards
Dave Hawley
www.ozgrid.com
"Elton Law" wrote in message
...
Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear
enough.

I'm looking for the min and the second lowest (after the first min is
found).
In thie case, I hope I can use function to sort out 24.59 after the
lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

Okay, assuming that the dates are always sequential, and there is no further
data below the table, try this:

=MIN(OFFSET($A$1:$A$8,MATCH($D1,$A$1:$A$8,0),))

If there is any data below the rows used for this table you would have to
use this:

=MIN(OFFSET($A$1:$A$8,MATCH($D1,$A$1:$A$8,0),,COUN T($A$1:$A$8)-MATCH($D1,$A$1:$A$8,0)))

Does this help?



"Elton Law" wrote in message
...

Hi Steve,

In this case, I would to get the lowest (which is very easy) and then get
the second lowest after the lowest is formed in date squenece.
I get the result which are 18.25 on 9 Feb and 24.59 on 1 April 2010.
In theory, the lowest is 18.25 and second min is 21.36 in the series.
But I need the second low after the the first low is done.
So the only second smallest after 18.25 should be 24.59.
21.36 should be ignored. Can any function be done this. thanks indeed for
help. Thanks

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

"Steve Dunn" wrote:

Hi Elton,

Please explain the "sequent issue"


"Elton Law" wrote in message
...
Hi Ozgrid,
Small and Large cannot solve the sequent issue.
Thanks


"ozgrid.com" wrote:

Try the SMALL & LARGE functions.


--
Regards
Dave Hawley
www.ozgrid.com
"Elton Law" wrote in message
...
Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear
enough.

I'm looking for the min and the second lowest (after the first min
is
found).
In thie case, I hope I can use function to sort out 24.59 after the
lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

Hi
Then for Lowest

=MIN(A1:A8)
or
=SMALL(A1:A8,1)
for the second lowest after the lowest (i.e the third lowest) then
=SMALL(A1:A8,3)

--
Regards
Roger Govier

Elton Law wrote:
Hi Steve,

In this case, I would to get the lowest (which is very easy) and then get
the second lowest after the lowest is formed in date squenece.
I get the result which are 18.25 on 9 Feb and 24.59 on 1 April 2010.
In theory, the lowest is 18.25 and second min is 21.36 in the series.
But I need the second low after the the first low is done.
So the only second smallest after 18.25 should be 24.59.
21.36 should be ignored. Can any function be done this. thanks indeed for
help. Thanks

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

"Steve Dunn" wrote:

Hi Elton,

Please explain the "sequent issue"


"Elton Law" wrote in message
...
Hi Ozgrid,
Small and Large cannot solve the sequent issue.
Thanks


"ozgrid.com" wrote:

Try the SMALL & LARGE functions.


--
Regards
Dave Hawley
www.ozgrid.com
"Elton Law" wrote in message
...
Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear
enough.

I'm looking for the min and the second lowest (after the first min is
found).
In thie case, I hope I can use function to sort out 24.59 after the
lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

Try these non volatile formulas:

In D1: =MIN(A1:A8)
In D2: =MIN(IF((A1:A8D1)*(B1:B8VLOOKUP(D1,A1:B8,2,)),A1 :A8))

The first formula normally enter, the second formula press ctrl+shift+enter,
not just enter.



"Elton Law" wrote:

Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear enough.

I'm looking for the min and the second lowest (after the first min is found).
In thie case, I hope I can use function to sort out 24.59 after the lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10

Hi Teethless Mama,
Thanks for your reply.
Yours work too. I have tried. I'm very much appreciated for your help. Thanks

"Teethless mama" wrote:

Try these non volatile formulas:

In D1: =MIN(A1:A8)
In D2: =MIN(IF((A1:A8D1)*(B1:B8VLOOKUP(D1,A1:B8,2,)),A1 :A8))

The first formula normally enter, the second formula press ctrl+shift+enter,
not just enter.



"Elton Law" wrote:

Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear enough.

I'm looking for the min and the second lowest (after the first min is found).
In thie case, I hope I can use function to sort out 24.59 after the lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Thanks indeed.

21.36 22-Jan-10
35.04 28-Jan-10
36.34 02-Feb-10
18.25 09-Feb-10
57.50 19-Feb-10
67.52 02-Mar-10
26.85 18-Mar-10
24.59 01-Apr-10