Easy if there are no duplicates in the data. Say we have unsorted data in A1
thru A100, In B1 enter:

=SMALL(A1:A100,ROW()) and copy down
--
Gary''s Student - gsnu200850


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