Replace this:

COUNTA(A$1:A$15)

With this:

COUNTIF(A$1:A$15,"?*")

--
Biff
Microsoft Excel MVP


"Dano" wrote in message
...

Copy down until you #NUM! errors. Or, if you want an error trap:

=IF(ROWS(B$1:B1)<=COUNTA(A$1:A$15),INDEX(A$1:A$15, MATCH(SMALL(IF(A$1:A$15<"",COUNTIF(A$1:A$15,"<"&A $1:A$15)),ROWS(B$1:B1)),IF(A$1:A$15<"",COUNTIF(A$ 1:A$15,"<"&A$1:A$15)),0)),"")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


That worked out great. However I bring in all of the names I am using
to the front page of my worksheet using references to other
workpages. So the "blank" cells really arn't blank they have a
formula reference that is refering to a blank cell. The result is
the Array alphabetizes it perfectly but all cells which refer to a
cell that is blank are at the bottom of the array resulting in
#NUM! .

Is there a way to have those cells in the array which refer to blank
cells also be "blank"?

Thanks so much,

Dan