VBA Script to find unique items

[Gor_yee]

Hi there everyone,

I hope you can help me. I have 2 columns.

In Column A - I have a number of stores that can have different/same
numbers
In Column B - I have a number of items that can have different/same
numbers

How can I show in say "C1" the unique items, for eg. Store Sydney -
Item - Happy Balloons


and so on... hope you can help. Thanks

 

[Don Guillett Excel MVP]

Hi there everyone,

I hope you can help me. I have 2 columns.

In Column A - I have a number of stores that can have different/same
numbers
In Column B - I have a number of items that can have different/same
numbers

How can I show in say "C1" the unique items, for eg. Store Sydney -
Item - Happy Balloons

and so on... hope you can help. Thanks

"If desired, send your file to dguillett @gmail.com I will only
look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."