C
ceemo
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),"")
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),"")