View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Cortez Cortez is offline
external usenet poster
 
Posts: 38
Default Automatic Data Sort?

Are you wanting to select the cell, highlight it, populate other cells
with it, etc? Can you explain more about what you want to happen?

The median() command will help if you are looking for the number that
divides a range of values evenly.

=IF(A1<MEDIAN(A1:A20),1,0)

TK

On Apr 30, 10:54*am, Scott wrote:
Is there a way to automatically sort data without doing it manually? *For
instance, I want to select the lowest 10 values of 20, etc. from a range of
data that is driven by references? *

Thanks!