Need help sorting a database

  • Thread starter Thread starter BigBuck98
  • Start date Start date
B

BigBuck98

I have a database made up of members of our local little league. This
includes the players names, addresses and various other items. Some of the
families have more than one player in the league and when I do a sort on the
addresses I get more than one line for some addresses.
We would like to do a mailing to each of the families in the league only
using their address. Is there a way to get rid of the duplicate addresses
that I get for some of the families so that I can print only one label to
each family? I am using Excel 97.
Thanks,
Gordon
 
Gordon

I use Data>Filter>Advanced Filter...

Copy the headings for the addresses and paste them to the right of your
current data. In the dialog that results from the menu options above,
select the original addreses as the database range. Select the copied
headers and the empty cells directly below them and select a cell to the
right of the copied labels as the 'copy to' area.

Now select 'Unique records only' and all should be well.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Gordon

I would be tempted to use Word MailMerge for making the labels with Excel as
the source file. Excel does not do a good job with labels on its own.

In that case, you would select by query the addresses you want when you set up
your fields in Word for the Merge.

For hints and tips on MailMerge see........

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

To answer your question literally.....

Insert a new worksheet.
Select your sorted address column range on original sheet.
Data>Filter>Advanced Filter.
Check "Unique records only" and "copy to a new location".

Your "listrange" will be already entered. In the "copy to" click on the
Collapse Dialog button and select your new worksheet A1.

OK your way out. You now have a sheet with unique addresses. Note: you will
only get one of the league player's names for each address.

Gord Dibben XL2002
 
Thanks Nick that worked great.
Gordon
Nick Hodge said:
Gordon

I use Data>Filter>Advanced Filter...

Copy the headings for the addresses and paste them to the right of your
current data. In the dialog that results from the menu options above,
select the original addreses as the database range. Select the copied
headers and the empty cells directly below them and select a cell to the
right of the copied labels as the 'copy to' area.

Now select 'Unique records only' and all should be well.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
Click to expand...
 
Back
Top