I am not new to Excel but until now didn't use it in a sophisticated way. I am stuck with a Table, where I am not able to get to my target.

What am I trying to do is the following in:

As you can see in the below picture, I did some experimenting before going back to my table and Google was of course my good old friend to help me find a solution

Row A is my Example, where I try to get data out from. I found a formula, to remove the blanks and show them in Row C. The Formula I used is the following:

=IFERROR(INDEX($A$2:$A$17, SMALL(IF(LEN($A$2:$A$17)=0,"", ROW($A$2:$A$17)-MIN(ROW($A$2:$A$17))+1), ROW(A1))),"")

The next formula in Row D is removing the duplicates and is ordering it in alphabetical order:

=IFERROR(INDEX($C$2:$C$11, MATCH(SMALL(IF(COUNTIF($D$1:D1, $C$2:$C$11)=0, COUNTIF($C$2:$C$11, "<"&$C$2:$C$11), ""), 1), COUNTIF($C$2:$C$11, "<"&$C$2:$C$11), 0)),"")

**Now comes the problem!**

If we have a look at Row F, as you can see, I have my table called "Test" and the Row is called "Example_with_a_table" (This ridiculous name is only used as an example).

Is there a way, I can extract all the data from the Table and have the same result like in Row D? It doesn't matter if the solution is within the Table or not, as long as I do get the result.

Where I am struggling is, that with the result in Row D, I am referring to a range but in a Table, I am addressing the Table itself with the [@[Example with a table]],

therefore, I assume, I have to address my request in a different way but I have no clue how or if it is possible with the formulas I started, not sure how to change it

to read from the table.

May I challenge you?

Thank you,

Mike