autofilter will work, but i need it as a function. i need to return the
values to a sencond worksheet


"Teethless mama" wrote in message
...
AutoFilter is a easy solution

"jiwolf" wrote:

I have a list that has two columns.. In column A is a list of containers.
in
column B is a list of components.

The containers in A can have multiple components in them i.e.

Cont Comp

1 xyz
1 ABC
1 DEF
2 aaa
3 bbb
3 baa


how can I get a list of every component that appears in a given
container?
Vlookup returns a component in a given box, but not EVERY component?


ideas anyone?