hide duplicate addresses in Excel

[DbaseGuy]

I manage a database for a school. when sending mailings home we often print
two labels to the same home due to siblings in the same school.
Is there a way to filter out duplicates?

 

[Barb Reinhardt]

You could use the COUNTIF() function to determine if you have duplicates.
Check this out:

http://www.cpearson.com/excel/duplicat.htm