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 |
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) |