Count inputs

Is there a way to count how many different inputs exist in a column?

And is there a way to have excel output all the different variables?

So if I have a row that says Dog, cat, dog, horse, horse, cat, How do I get it to tell me that there is 3 variables, and then output Dog, cat, horse to tell me what the 3 variables are.