Re: Sorting Text Range with Formula

From: immanuel (ismits.no_at_spam.msn.com)
Date: 02/06/04


Date: Thu, 5 Feb 2004 21:48:32 -0500

Thanks, Frank,

I already created an array formula to sort text entries but was just
wondering if maybe someone had a better, more efficient way...

/i.

"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:OzEdr8j6DHA.2488@TK2MSFTNGP09.phx.gbl...
> hi
> have a look at MOREFUNC.XLL (http://longre.free.fr/english)
> it includes the functions HSORT/VSORT for your specific issue
>
> HTH
> Frank
>
> immanuel wrote:
> > Just wondering if anyone has developed a single multi-cell array
> > formula for sorting a range containing text. Would anyone know if
> > this has been done?
> >
> > /i
>
>