Re: Sorting two columns of data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I suppose it's possible, I've not tried to do it yet......I do know that
drop-down commands won't come through on the macro-recorder........perhaps
someone from the Programming Group could suggest a bit of code.......or
maybe the folks at ASAP could help.

Vaya con Dios,
Chuck, CABGx3



"Max" <Max@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A989916F-E438-4F04-BBA8-6DBA69422E7D@xxxxxxxxxxxxxxxx
> 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" <Max@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:0F1406E8-3EA6-4751-BA38-7AD0E8E26D73@xxxxxxxxxxxxxxxx
> > > 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.
> >
> >
> >


.

Relevant Pages