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