You can try filtering on unique values with a copy to another region

Tyro

"carlo" wrote in message
...
On Jan 15, 11:05 am, jjr1975
wrote:
Have a customer database with everyone's name, address, etc. Most of the
time
each family member is a client and therefore they have their own line
item. I
have direct mailers that I wish to send out to all my customers homes, but
I
only want to send one per household. How can I remove the extra rows in
the
spreadsheet so I only have one line item per address?? Your help is
apprechiated.

There are probably a lot better solutions, but this one works fine for
me:
I assume you have a headerrow, if not: you need one.
So 1 is your Header Row.
Go to the next new column in Row 2 and enter this formula:
=COUNTIF(INDIRECT("A2:A" & ROW()),A2)
You have to change all "A" with your Address Column. For example if
you have your address in Column H the formula looks like:
=COUNTIF(INDIRECT("H2:H" & ROW()),H2)
Then apply an autofilter to your whole table:
select row 1, go to data -- Filter -- AutoFilter
Go to your new Column and select Custom in the Filter Dropdown and
enter "equals 1"

Then Copy your Table, goto a new sheet A1, right click, paste special
as values.
And then you have a clean database.

hope you understand what i mean, otherwise just tell me and i try to
explain better.

Cheers
Carlo