Return a distinct list in alphabetical order

[deacon10]

Good morning all,

I am hoping someone can help with a tricky formula that I am massively struggling with?

I am trying to return a list of distinct values in ColumnA where they are found in ColumnT. Also the distinct list in columnA needs to be in alphabetical order.
There is about 30000 rows of 153 distinct values in column T and more can be added at anytime.

The formula below is in column A and looks like it is giving me a distinct list. Unfortunately it does not do it in alphabetical order.
=IFERROR(INDEX(Sheet2!$T$2:$T$30000, MATCH(0, COUNTIF($J$1:J1, Sheet2!$T$2:$T$30000), 0)), "")

The data looks something like this...

Sheet1	Sheet2
A (row 1)	T (row 1)
Formula?	test
Formula?	report
Formula?	test
Formula?	report
Formula?	test
Formula?	delete
Formula?	delete

Is this possible?

Any help massively appreciated

 

[Fluff]

How about

=SORT(UNIQUE(FILTER(Sheet2!$T$2:$T$30000,Sheet2!$T$2:$T$30000<>"")))

you need to clear col A before putting this formula in.

 

[deacon10]

How about

=SORT(UNIQUE(FILTER(Sheet2!$T$2:$T$30000,Sheet2!$T$2:$T$30000<>"")))

you need to clear col A before putting this formula in.

You are my hero!

 

[Fluff]

You're welcome & thanks for the feedback.