Sorting a 2d array by more than 1 column

2 Jun 2005 9:29 AM

gonkowonko

Hi

i have a array for example 2columns

1 = name

2 = status (1-5)

i want to sort by status then by name so a list like list

joe bloggs 1
candy baby 1
spoggins 2

gotos

candy baby 1
joe bloggs 1
spoggins 2

I have looked for things like bubblesort turbo sort and other methods
and i just cant get the thing to work :( even debating to create a temp
database table and insert and requery but that takes a lot longer

Can anyone help?

2 Jun 2005 11:00 AM

RB Smissaert

Have a look at:

http://xcell05.free.fr/

There are free array sorting functions in a .xll file.
These are for use with Excel, but maybe they can be used with VB. They are
very fast and can sort on mulitple columns.

RBS

<gonkowo***@gmail.com> wrote in message
Show quoteHide quote

news:1117704546.935461.279790@g47g2000cwa.googlegroups.com...
> Hi
>
> i have a array for example 2columns
>
> 1 = name
>
> 2 = status (1-5)
>
> i want to sort by status then by name so a list like list
>
>
> joe bloggs 1
> candy baby 1
> spoggins 2
>
> gotos
>
> candy baby 1
> joe bloggs 1
> spoggins 2
>
> I have looked for things like bubblesort turbo sort and other methods
> and i just cant get the thing to work :( even debating to create a temp
> database table and insert and requery but that takes a lot longer
>
> Can anyone help?
>

2 Jun 2005 3:11 PM

gonkowonko

woo hoo sorted it!!!

took loads of code but its works and works very quick

thanks for your help RBS appreciated

2 Jun 2005 4:05 PM

RB Smissaert

Nice you got it sorted.
I have never used this in VB.
Could you post any relevant bits of code to make this work in VB?
Or just give a short summary of the essential steps?
Thanks.

RBS

<gonkowo***@gmail.com> wrote in message
Show quoteHide quote

news:1117725073.331469.196990@g49g2000cwa.googlegroups.com...
> woo hoo sorted it!!!
>
> took loads of code but its works and works very quick
>
> thanks for your help RBS appreciated
>