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...
Is this possible?
Any help massively appreciated
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