Data sorting formula

G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Sorting 1
Cannot sort a table containing text 5
Adding a word to a numerical field 0
Copy addition formula of non-consecutive horizontal cells 2
How to clear areas of a locked Doc after each use-- 0
Sorting Coloumns that are Formula's 1
refresh? 2
Sorting data with a formula 4

Top