View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EllenM EllenM is offline
external usenet poster
 
Posts: 78
Default Get lower half of a column of numbers

Hello,
I'd like to pick out the lower half of a column of numbers, basically
anything <median(a2:a50). Is there a way to do this as a sort? I'd like to
remove the upper half. After that I'd like to sort on another field.

Thanks,
Ellen