D
Dano
Everyday I have to update several lists.
They arrive to me on an excel spreadsheet in random order.
They are in one column with spaces mixed in throughout the list.
I want to be able to cut and paste those lists into my spreadsheet and
have them automatically re-order themselves in alphabetical order and
have the blank cells ignored.
I know about Excel's SORT function. I have been using it for years.
It will save me about 12 mins each morning if I can skip that step.
(Which would save me a workweek each year.)
I have gotten this far using an array:
=INDEX($A$1:$A$99,MATCH(SMALL(COUNTIF($A$1:$A$99,"<"&$A$1:$A$99),ROW
(B1)),COUNTIF($A$1:$A$99,"<"&$A$1:$A$99),0))
This sorts the list in column A. The problem is the blank cells
appear at the top pf the list. I need the list to start in B1 and
the blank cells to be ignored.
I don't want to use VBA or a Macro to do it either.
Thanks,
Dan
They arrive to me on an excel spreadsheet in random order.
They are in one column with spaces mixed in throughout the list.
I want to be able to cut and paste those lists into my spreadsheet and
have them automatically re-order themselves in alphabetical order and
have the blank cells ignored.
I know about Excel's SORT function. I have been using it for years.
It will save me about 12 mins each morning if I can skip that step.
(Which would save me a workweek each year.)
I have gotten this far using an array:
=INDEX($A$1:$A$99,MATCH(SMALL(COUNTIF($A$1:$A$99,"<"&$A$1:$A$99),ROW
(B1)),COUNTIF($A$1:$A$99,"<"&$A$1:$A$99),0))
This sorts the list in column A. The problem is the blank cells
appear at the top pf the list. I need the list to start in B1 and
the blank cells to be ignored.
I don't want to use VBA or a Macro to do it either.
Thanks,
Dan