Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unique addresses
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unique addresses
On the Data tab, in the Data Tools group, click Remove Duplicates.
Send the fee to your favourite charity. -- Russell Dawson Excel student "Doug Mc" wrote: 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 . |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unique addresses
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 "Russell Dawson" wrote in message ... On the Data tab, in the Data Tools group, click Remove Duplicates. Send the fee to your favourite charity. -- Russell Dawson Excel student "Doug Mc" wrote: 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 . |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unique addresses
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unique addresses
You want to remove the duplicates?
In 2000 use DataFilterAdvanced Filter to copy Unique Records to another location. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 09:42:00 -0600, "Doug Mc" wrote: Is there some other way to do it? "Don Guillett" wrote in message ... That feature not added until xl2007 -- Don Guillett Microsoft MVP Excel SalesAid Software "Doug Mc" wrote in message ... 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 "Russell Dawson" wrote in message ... On the Data tab, in the Data Tools group, click Remove Duplicates. Send the fee to your favourite charity. -- Russell Dawson Excel student "Doug Mc" wrote: 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 . |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unique addresses
Thanks Gord.
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... You want to remove the duplicates? In 2000 use DataFilterAdvanced Filter to copy Unique Records to another location. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 09:42:00 -0600, "Doug Mc" wrote: Is there some other way to do it? "Don Guillett" wrote in message .. . That feature not added until xl2007 -- Don Guillett Microsoft MVP Excel SalesAid Software "Doug Mc" wrote in message ... 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 "Russell Dawson" wrote in message ... On the Data tab, in the Data Tools group, click Remove Duplicates. Send the fee to your favourite charity. -- Russell Dawson Excel student "Doug Mc" wrote: 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 . |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unique addresses
You're welcome.
Gord On Tue, 9 Feb 2010 15:49:51 -0600, "Doug Mc" wrote: Thanks Gord. "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . You want to remove the duplicates? In 2000 use DataFilterAdvanced Filter to copy Unique Records to another location. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 09:42:00 -0600, "Doug Mc" wrote: Is there some other way to do it? "Don Guillett" wrote in message . .. That feature not added until xl2007 -- Don Guillett Microsoft MVP Excel SalesAid Software "Doug Mc" wrote in message ... 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 "Russell Dawson" wrote in message ... On the Data tab, in the Data Tools group, click Remove Duplicates. Send the fee to your favourite charity. -- Russell Dawson Excel student "Doug Mc" wrote: 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
How to pick out unique components in a list with unique and common | Excel Discussion (Misc queries) | |||
How do I count unique email addresses across multiple worksheets? | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) |