Hi,

Sorry I have already asked this question but the answers were given in VBA,
which I would rather avoid using if possible. Is there any way of sorting a
vertical list of data such as B, A, B, A, C, D, C into A, B, C, D using only
a formula?

I have this formula which I use to delete the empty cells from a list which
I have been trying to adapt to do this but without any luck. Not sure if its
any use for anyone to answer the question.

Thanks for your help

=INDEX($X$2:$X$5000;SMALL(IF($X$2:$X$5000<"";ROW( INDIRECT("1:"&ROWS($X$2:$X$5000))));ROWS($1:1));0)