Last Items in a Growing List

[deepheat101]

Greetings...

I have an unsorted column called "Animals" that (surprisingly) contains a list of animals in varying quantities (anything from 4 to 30 occurances in no specfic order, other than the order in which they were entered)

In the next column along I would like an "X" to appear in the same row if that animal is the last occurance of that animal in the unsorted list...

For example,

Brown Bear    X
Elephant
Aardvark
Lion          X
Tiger
Tiger
Tiger
Aardvark      X
Elephant      X
Tiger         X
Guinea Pig    X

As the animal list is updated via a UserForm, the "X" will need to be updated at the same time.

Brown Bear    X
Elephant
Aardvark
Lion          X
Tiger
Tiger
Tiger
Aardvark      X
Elephant      
Tiger         X
Guinea Pig    X
Elephant      X

(notice the new entry "Elephant" now has an "X" next to it, while the previous Elephant entry has had its "X" removed.

Where do I start?? (I need to keep the list in the original order)

Many Thanks in advance

 

[Andrew Poulsom]

In B1 enter:

=IF(COUNTIF(A$1:A1,A1)=COUNTIF(A:A,A1),"X","")

and copy down.

 

[deepheat101]

Once again Andrew, you come to my rescue.

Many Thanks