Collecting Cell Values

Moin auch.

So I attach an example worksheet. The outcome there should be a list that looks like follows (whereas the order doesn't relly matter):

Mueller
Meier
Schmitz

How can I do it? I don't want Mueller to appear twice and I don't want empty cells in between the lines.

Thanks a lot in advance.

Thanks a lot for this.
The problem is just, that the data comes from two different worksheets, so there could still be double entries. Moreover, I would like to have the list just as an output, w/o the manual sorting.

I basically think it could be something like:
look for the first not-empty cell, that is not already in the List. Take it and enter it into the list. Do this to the end of the list.

But I have no idea if/how that works. Even though this seems to be like a very simple procedure, that every child could do .

Thanks again,

after having thought of the whole thing tonight, I managed to integrate the two worksheets into one worksheet and also let the check run both in the same sheet.
Now I have this list of "Names", thanks to you, every name is just appearing once. All I need now is a function that looks up all the the names and puts them in a list automatically w/o manually sorting the list or something.
I think I can do that with a macro, but it would be better if there were none in the file.

Thanks in advance for any hints.

This is awesome.
I have not really an idea, what the formula does, but it works perfectly. I did a macro, that does the same, but it is a macro after all and it takes a further click, so the formula is just great.

I have one (hopefully final) question:
Now I want to mark all the Cells that include Names that are on this newly created list in red. Right now I use conditional formatting and say "Formula Is" and =match("Name","Column in which all the names are")
This works in so far as it marks all the cells that are filled with something in red. Any ideas.

Yes, I saw that all the names are in the list. As I am working with another list, this wasn't relevant though.

The point is, that I didn't enter the "0" in the end of the formula, now it works.
Thank you very much for your support. It is awesome to have people who devote their free time to supporting others like that.

Sorry, I am back again. Can I also have conditional formatting for an array that is not only a column but a wider area? I would like to enter previous months data there.
Thanks again.