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.

See if thios will get you started...

	A	B
2	aa	aa
3	bb	bb
4	cc	cc
5	aa	dd
6	dd	ee
7	bb
8	dd
9	ee

B2=IFERROR(INDEX($A$2:$A$9,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$9),0,0),0)),"")
copied down