hide duplicate addresses in Excel
 

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?

hide duplicate addresses in Excel
 

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

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

"DbaseGuy" wrote:

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?