a formula to extract unique records

[residnt]

Hello There,

I have another question for you all. What I am trying to do it extract unique data from a list that I have. I know that I can do this through filters but this is not what I want. What I have is a list that looks like this

shoes
shoes
shoes
shirt
shirt
shoes
shirt
pants
shirt
pants
hats

now what I am wondering with out using a macro or a filter if there is a way to use a formula to extract the unique data and end up with a list like this

shoes
shirt
pants
hats

Any help would be greatly appreciated.

Thanks
Residnt

 

[wilgry]

You could use a pivot table, Access is also good a this

 

[residnt]

bummer I was hoping I wouldn't have to do that. I can just use a filter if I had to I just wanted to have a unique list. I will post if I figure something out.

Thanks
Residnt