i have a column containing names but they are not in an order and have
blank spaces between them. Is there a way they can be sorted in order
into a new column without using the genral sort method.

Ive used the below formula for doing siimilar using numbers but this
does not work for alpha's

=IF(ISNUMBER(SMALL($A$5:$A$12,ROW()-ROW($A$5)+1)),SMALL($A$5:$A$12,ROW()-ROW($A$5)+1),"")


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=383495

"ceemo" ha scritto nel
messaggio ...

i have a column containing names but they are not in an order and have
blank spaces between them. Is there a way they can be sorted in order
into a new column without using the genral sort method.

Ive used the below formula for doing siimilar using numbers but this
does not work for alpha's


=IF(ISNUMBER(SMALL($A$5:$A$12,ROW()-ROW($A$5)+1)),SMALL($A$5:$A$12,ROW()-ROW
($A$5)+1),"")

hy.
|A | B |
--+--+------+
1|F |C |
2|G |F |
3| |G |
4|C |T |
5|V |V |
6|T | #NUM!|

In B1 an array formula to drop in B2:B6
=INDEX($A$1:$A$6,MATCH(SMALL(IF($A$1:$A$6="","",CO UNTIF($A$1:$A$6,"<"&$A$1:$
A$6)),ROW(A1)),IF($A$1:$A$6="","",COUNTIF($A$1:$A$ 6,"<"&$A$1:$A$6)),0))
ivano

beautiful just like the gods would have wrote


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=383495