Hi Max..........

If you're into VBA, you can record a small macro to cut the second column
and paste it to the bottom of the first column, then select it and sort,
ascending, then call the nifty macro that Chip Pearson has on his site
www.cpearson.com called "Public Sub DeleteDuplicateRows()"..........I just
tried it on your sample data and it works really good........no extra
columns or formulas needed.........

That way you could import your data, then select column A and then just run
the macro(s)......that's pretty automatic......

Vaya con Dios,
Chuck, CABGx3



"Max" wrote in message
...
Hello Chuck,
I have downloaded the Utilities pack you suggested. Thank you.
Would I be able to automate this process using these utilities?
My intent was to be able to import data from a database and have the sort
function automatic. Not having to do any manual tasks.

Thank you for your help and advise.

"CLR" wrote:

Hi Max..........

There are various ways to do what you want, but personally I prefer to
just
cut and paste the second column onto the bottom ot the first column and
then
use "ASAP Utilities" to delete all the duplicates in one fell-swoop.
This
is just one of the features of the ASAP Utilities add-in which may be
obtained free at www.ASAP-utilities.com

Vaya con Dios,
Chuck, CABGx3




"Max" wrote in message
...
Hi,
I have two columns of numbers, that I need to sort into one column.
They are not sequential and some of the same numbers appear in each
column.
In the resulting column I need all the numbers listed in ascending
order
without duplication. The first column will range from 1 to 120 but not
with
all the numbers in the list from 1 to 120. (some numbers will be
missing).
The second column may have duplications of the first column, but with
some
unique numbers. eg (short list)

1 1
5 5
13 16
16 19
19 34
21 37
24 49
29 50
33 51
36 54
37 60
39 72
40 85
42 102
50
51
54
60
61
65
66
69
70
How can I sort these using functions.