LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spike9458
 
Posts: n/a
Default Formula to recognize Duplicates

I have a list of about 6000 line items. Among other things, the data
includes names and email addresses. There are many duplicate entries,
checking line by line for 6000 lines is not very appealing to me.

Can someone help me to devise a formula or other way to do this?

Thanks,

--Jim


 
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
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
Formula that recognizes duplicates Courtneyf04 Excel Worksheet Functions 7 June 8th 05 07:06 PM
Create formula for detecting duplicates Courtneyf04 Excel Worksheet Functions 1 June 7th 05 09:47 PM
conditional formula to recognize day of the week from date tiw Excel Discussion (Misc queries) 4 April 20th 05 06:19 PM
Offset & Match Formula Shows Duplicates Joe Gieder Excel Worksheet Functions 14 December 7th 04 05:35 PM


All times are GMT +1. The time now is 08:25 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"