View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Dunn Steve Dunn is offline
external usenet poster
 
Posts: 193
Default Look for Min and second Min

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