The last argument of the UNIQUE function determines if it returns a distinct or unique list. To extract a list of unique values in Excel use one of the following formulas. If there is enough space empty cells underneath the formula the formula will work as intended.
To use MATCH to find an actual question mark or asterisk type first.
And paste it down till the cell D12 Shortcut key. When using this formula we do not have to know how many unique values there are as the IFERROR function ensures a blank is returned once the bottom of the unique list is reached. Copy down the formula. If you want to sort the list of names you can add the SORT function.