Re: Sorting two columns of data
- From: "CLR" <croberts@xxxxxxxxxxxxxxx>
- Date: Sun, 12 Jun 2005 20:30:48 -0400
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" <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.
> >
> >
> >
.
- References:
- Sorting two columns of data
- From: Max
- Re: Sorting two columns of data
- From: CLR
- Re: Sorting two columns of data
- From: Max
- Sorting two columns of data
- Prev by Date: Re: substitute
- Next by Date: Re: Lists
- Previous by thread: Re: Sorting two columns of data
- Next by thread: keep totals from month to month?
- Index(es):
Relevant Pages
|
