I am trying to auto generate a list on a worksheet based on conditions in
another i.e.

Worksheet 1 Contains the list below,

tree 1
Car 2
Fruit 1
tea 1

I want a list to be generated in worksheet2 containing just,

Tree
Fruit
Tea

I was hoping to do this with in sheet formula as opposed to macro etc (don't
understand them)

Thanks in Advance

Ceptor54