View Single Post
  #1   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

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