View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to determine the values from a list?

Referring to the post in General Question

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 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