Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,355
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Excel session when running at the batch mode xiaoxshi Excel Discussion (Misc queries) 1 July 23rd 06 03:54 PM
Excel needs a special cell format for MAC addresses Don Excel Discussion (Misc queries) 0 July 20th 06 02:16 PM
How to combine Excel 2002 files and remove duplicate records? Dave542 New Users to Excel 4 April 6th 06 01:08 PM
Find duplicate records in Excel 2003 Wayne Excel Discussion (Misc queries) 1 March 29th 06 12:47 AM
Duplicate records in Excel Sheidsa Excel Discussion (Misc queries) 1 November 30th 04 12:23 AM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"