Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 14th 07, 04:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 31
Default Find duplicates in data with multiple criteria

Hello - We are trying to create a list for holiday cards this season.
However, when we imported everyone's information into an excel spreadsheet,
we received duplicates which were to be expected. I did a subproduct on two
of the fields, Last name and Company and managed to find over 400 duplicates.
We thought we were done. HOWEVER - Because some people have listed contacts
last name different or companies differently, this wasn't a complete check.

I was figuring maybe I need to also do a zip code and Last name check? I am
stuck. Any suggestions?

D.




  #2   Report Post  
Old December 14th 07, 04:56 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,593
Default Find duplicates in data with multiple criteria

Just repeat the SUMPRODUCT on different fields?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Danielle" wrote in message
...
Hello - We are trying to create a list for holiday cards this season.
However, when we imported everyone's information into an excel
spreadsheet,
we received duplicates which were to be expected. I did a subproduct on
two
of the fields, Last name and Company and managed to find over 400
duplicates.
We thought we were done. HOWEVER - Because some people have listed
contacts
last name different or companies differently, this wasn't a complete
check.

I was figuring maybe I need to also do a zip code and Last name check? I
am
stuck. Any suggestions?

D.







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
Sum multiple arrays of data according to criteria [email protected] Excel Worksheet Functions 7 July 25th 07 10:05 AM
find minimum of range based on multiple criteria Weissme Excel Worksheet Functions 3 May 21st 06 05:21 PM
Sorting Data by multiple criteria Eggtavius Excel Discussion (Misc queries) 2 January 12th 06 09:37 PM
Find duplicates between multiple XLS files Culley Excel Discussion (Misc queries) 1 December 2nd 05 09:50 PM
Compare data in two columns to find duplicates. Dan Excel Discussion (Misc queries) 2 October 5th 05 04:42 AM


All times are GMT +1. The time now is 01:35 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017