Hi,

Download and install the following add-in
http://www.download.com/Morefunc/300...-10423159.html and the use the
multi cell UNIQUEVALUES() array formula. Therefore, if the range is in
C6:C11, select range E6:E11 and use the UNIQUEVALUES(C6:C11,1) array
formula.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"LiAD" wrote in message
...
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)