That worked for 1,2 and 3.

there's 2 tables, same columns. how would i use that to sort the tables of
two columns?

does that make sense?


"Lars-Åke Aspelin" wrote:

On Mon, 3 Aug 2009 10:18:01 -0700, sluvian
wrote:

I'm trying to sorting numbers in two seperate rows.
1 4
5 6
3 2
i want them to sort, and end up looking like this
1
2
3
4
5
6

Assuming that you mean two columns (not rows) as shown in your example
and that the numbers are in columns A and B starting on row 1.

If a certain number can only be present in at most one of the columns,
you may try the following formula in cell C1:

=IF(ISERROR(MATCH(SMALL($A$1:$B$100,ROW()),A$1:A$1 00,0)),"",SMALL($A$1:$B$100,ROW()))

Change the 100 in all places to fit the maximum size of your data in
columns A and B.

Copy this formula to cell D1 and then fill cells C1:D1 down as far as
needed.

If a certain number can be present in both columns, you have to
specify what the input should look like. Should the number be on one
or columns in the output? If two columns, in which column should the
number be listed first.

Hope this helps / Lars-Åke