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.