auto fill B Column with content on A Column, sort, and no duplicate

Hi, I need help.

I need a formula to auto fill B Column with content on A Column, but I don't want to write the multiple again, just once and I need it to automatically sorted.

Please help.
Thank you

Data List
Cat Cat
Dog Dog
Cat Elephant
Cat Horse
Dog
Elephant
Horse
Horse
Elephant

hi,

Please find the attached sheet for your solution, there is a arry formula.

i have written formula in column "C" if you want this in column B just edit that formula..

in B2

=INDEX($A$2:$A$20, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$20), 0))

Hi,

Please find the attached file for same, in this file there is "Name range" created for see and edit range.

Press "CTRL+F3" and u can edit your list as long as your data.

If you use column B and enter this formula in B2 and fill down, you will get a series of values that in effect is the order of the list in column A.

Formula:

Please Login or Register  to view this content.

In column C enter this formula in C2 and fill down to retrieve the unique values in column A in order

Formula:

Please Login or Register  to view this content.