Prev: Comparing Lists
Next: Isolate text immediately preceding "("
From: Jessabez on 3 Jul 2008 13:48
I have a master file I am working on in which data on one tab is linked to
other tabs. I have a macro for them to be sorted, but when I sort, only the
numbers sort and then the words are bumped to the bottom of the sorting
block. I end up with numbers sorted and then a huge gap with the words sorted
at the bottom. Any suggestions to fix this?
From: Gord Dibben on 3 Jul 2008 14:27
That's how Excel sorts.

Numbers first then if your link formulas return "" they will appear then text.


Gord Dibben MS Excel MVP


On Thu, 3 Jul 2008 10:48:01 -0700, Jessabez <Jessabez(a)discussions.microsoft.com>
wrote:

>I have a master file I am working on in which data on one tab is linked to
>other tabs. I have a macro for them to be sorted, but when I sort, only the
>numbers sort and then the words are bumped to the bottom of the sorting
>block. I end up with numbers sorted and then a huge gap with the words sorted
>at the bottom. Any suggestions to fix this?

 | 
Pages: 1
Prev: Comparing Lists
Next: Isolate text immediately preceding "("