Sorting an Array

[Guest]

I have an array of 2 columns: A & B. A contains a Product Code and B
contains a Product Description which can sometimes be unique or sometimes the
same description. For example:
A1 B1
1 X8 ThingA
2 X8 ThingA
3 G9 WidgetA
4 S5 PartA
5 G9 WidgetB
6 X8 PartB
7 W1 StuffA
8 W1 StuffA
9 X8 ThingA

I need to be able to create a list, by Product Code, listing only one
occurrance per product description. Essentially, the same way a Filter
displays items in a column.

 

[Dave Peterson]

You could select column B.
Then Data|filter|advanced filter
check the unique entries box.

Then select that range, hit Edit|goto|special|visible cells only
and then copy that selection

Paste into a new location (worksheet???)

Debra Dalgleish has some instructions with pictures at:
http://www.contextures.com/xladvfilter01.html#FilterUR

 

[Guest]

Thanks Dave... This looks like it will work. Appreciate the tip.