The 'minimum' range? I don't understand. If you're looking at the top 50%
of numbers and you want to return the min/max from that range...

In B1 enter:
=SUMPRODUCT(MIN(SMALL(A1:A10,INT(COUNT(A1:A10)/2)+1)))

In B2 enter:
=SUMPRODUCT(MAX(SMALL(A1:A10,INT(COUNT(A1:A10)))))

Hope I understood you alright. These would return 42 and 99 from your
sorted list (placed in A1:A10). The items you said to look at were neither
the minimum range nor the maximum range, but a range from the middle of the
sorted list. This is why I'm hoping I understood what your requirements
were. If not, please post back.

HTH

--
Regards,
Zack Barresse, aka firefytr
MsgBox "fire" & "fytr" & Chr(64) & "vba" & "express" & Chr(46) & "com"



"Eric" wrote in message
...
Hi Zack Barresse:
If the list contains 100 numbers, then I need to select 50 numbers
covering the minimum range, such as following example with 10 numbers, and
I
need to select 50% of 10 = 5 numbers covering minimum ranges.

1,3,21,40,41,42,43,44,88,99

In this case, I should select 40,41,42,43,44
41 returns in cell B1
44 returns in cell B2

Thank you for any suggestions
Eric


"Zack Barresse" wrote:

Hi there Eric,

Which 50% of the numbers do you want to look at?

--
Regards,
Zack Barresse, aka firefytr
MsgBox "fire" & "fytr" & Chr(64) & "vba" & "express" & Chr(46) & "com"



"Eric" wrote in message
...
Does anyone have any idea on how to determine the values under
following
conditions?
Given a list of numbers sorted by ascending order from top to bottom
under
column A, I would like to determine the minimum difference on the range
within this list covering 50% of total numbers, and return the smallest
number within the range in cell B1 and the largest number within the
range
in
cell B2.
Does anyone have any suggestions?
Thank you in advance
Eric