Unique addresses

[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

 

[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

 

[Don Guillett]

That feature not added until xl2007

 

[Doug Mc]

Is there some other way to do it?

That feature not added until xl2007

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[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

 

[Doug Mc]

Thanks Gord.

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

 

[Gord Dibben]

You're welcome.


Gord

Thanks Gord.