Unique addresses

D

Doug Mc

You guys have helped me so much I feel like I need to send you a monthly
fee!

Anyway, I have a spreadsheet which has addresses in it. The addresses are
in order by House numbe and street name.
House number = Column H
Street name = Column I.

Is there some way I can capture the Number of Unique addresses?
I know I can use CountA, etc. but I don't know how to select the duplicates.

Thanks again for this and for all the other help you've given me!!
Doug Mcneill
 
D

Doug Mc

Hi Russell,
I clicked on Data and I don't see a Data Tools choice.
I'm using Office 2000. Is that the problem? Or is it something else?

Doug
 
G

Gord Dibben

You want to remove the duplicates?

In 2000 use Data>Filter>Advanced Filter to copy Unique Records to another
location.


Gord Dibben MS Excel MVP
 
D

Doug Mc

Thanks Gord.


Gord Dibben said:
You want to remove the duplicates?

In 2000 use Data>Filter>Advanced Filter to copy Unique Records to another
location.


Gord Dibben MS Excel MVP
Click to expand...
 
Top