View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default Look for Min and second Min

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