On Wed, 22 Jul 2009 02:10:02 -0700, LiAD
wrote:

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 )

You could use the Data/Sort and then the Advanced Data Filter wizards from the
main tool bar to extract the Uniques in sorted order.
--ron