One crack at deciphering this ..

Assuming source data in A2 down,
with data being all text numbers (or a mix of text and real numbers)

Place in B2, then array-enter* the formula by pressing CTRL+SHIFT+ENTER,
instead of just pressing ENTER:
=IF(ISNUMBER(MATCH(ROW(A1),A:A,0)),ROW(A1),"")

Copy B2 down to B21. The source data in A2:A21 will be "sorted" neatly into
B2:B21 in ascending order exactly where they should appear, with the rest of
the cells appearing blank, as required.

*Done correctly, Excel will wrap curly braces around the formula: { ... }
You should see this happening within the formula bar, as a visual check that
the formula is correctly array-entered. If these curly braces don't appear,
click inside the formula bar and try it again (CTRL+SHIFT+ENTER).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"maperalia" wrote:
Could you help me with tis matter please?
I have these values that came from a text file:
Found
10
20
4
12
8
However, I want to know how can I sort them by leaving the row blank where
that number does not exist?. The numbers are from 1 to 20..
Basically, I want to have a twenty rows showing just the numbers found and
leave the row empty for the rest.
Thnaks in advance.
Maperalia.