Is there a formula that can sort a range of data
G Gary''s Student May 1, 2009 #2 Easy if there are no duplicates and the data is numeric. Say we have un-sorted values in column A. In B1 enter: =SMALL(A:A,ROW()) and copy down
Easy if there are no duplicates and the data is numeric. Say we have un-sorted values in column A. In B1 enter: =SMALL(A:A,ROW()) and copy down
