|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 8th, 2010, 07:01 PM
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
February 8th, 2010, 08:21 PM
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
February 8th, 2010, 11:31 PM
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
February 9th, 2010, 12:35 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Unique addresses
|
|
#6
February 9th, 2010, 05:47 PM
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
February 9th, 2010, 09:49 PM
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
February 10th, 2010, 12:16 AM
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 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
