Re: How to classify the values of a matriz

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

From: Frank Dulk (fdulk_at_bol.com.br)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 10:45:06 -0300

Does know where I can find?

"Michel Walsh" <vanderghast@VirusAreFunnierThanSpam> escreveu na mensagem
news:u$Q1a2njEHA.3896@TK2MSFTNGP15.phx.gbl...
> Hi,
>
>
> You have to sort the value (in ascending or descending order) using a
> VBA algorithm, since VBA does not have "template" (C++) which would
> consider the array as an object by itself ( as in dotNet ) on which you
can
> use the method "Sort". So, you have to produce your own function that take
> an array as input and return a sorted array for output. QuickSort
algorithm,
> on Google, should return many hits. VBA Developer's Handbook, at Sybex,
by
> Ken Getz, also has such a method.
>
>
>
> Hoping it may help,
> Vanderghast, Access MVP
>
>
>
> "Frank Dulk" <fdulk@bol.com.br> wrote in message
> news:O50zImijEHA.1904@TK2MSFTNGP09.phx.gbl...
> > How to classify the values of a matriz, for instance,
> >
> > Dim MinhaMatriz(10) as integer
> >
> > After defining the values for the head office, how to come back the data
> > in
> > growing order?
> >
> > Does have to be in the arm?
> >
> >
>
>

Relevant Pages

  • Re: Formula not working
    ... My data is on sheet 3 in columns a and b. ... but I was thinking Match and Index since the ascending ... range of cells and then do an ascending sort on them and see how Excel sorts ... Note how the last array containing numbers is actually the third argument ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Formula not working
    ... Valko" wrote: ... lookup_vector *must* be sorted ascending. ... range of cells and then do an ascending sort on them and see how ... Note how the last array containing numbers is actually the third ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Formula not working
    ... toppers NOSPAMjohntopley.fsnet.o.uk ... but I was thinking Match and Index since the ascending ... range of cells and then do an ascending sort on them and see how Excel sorts ... Note how the last array containing numbers is actually the third argument ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Formula not working
    ... Microsoft Excel MVP ... lookup_vector *must* be sorted ascending. ... range of cells and then do an ascending sort on them and see how ... Note how the last array containing numbers is actually the third ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Formula not working
    ... but I was thinking Match and Index since the ascending ... range of cells and then do an ascending sort on them and see how Excel sorts ... Note how the last array containing numbers is actually the third argument ... the IF function and not the third argument of the LOOKUP function. ...
    (microsoft.public.excel.worksheet.functions)