I love this forum! need help again!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EMCUE - 17 Jun 2006 00:09 GMT

1) I have a contact list for previous conference years. 1999-2006. I
want to find all the duplicates and have the duplicates pulled onto
either another worksheet or an area on the same worksheet.

2) I had to previously pull a random sample of potential duplicates for
another database import. I had about 350 random numbers from a
population of 3900, and then found those contacts associated with the
random numbers. This list was in alpha order. In the future is there a
way to extract the contacts associated with the random number set, such
that I do not have to manual deleted contacts?

Future Thanks!

Again, I love this forum! :) :) :) :cool: ;) :)

Signature

EMCUE

Reply to this Message

Bernard Liengme - 17 Jun 2006 00:45 GMT

Chip has lots of stuff on duplicates and comparing worksheets
see www.cpearson.com

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> 1) I have a contact list for previous conference years. 1999-2006. I
> want to find all the duplicates and have the duplicates pulled onto
[quoted text clipped - 10 lines]
>
> Again, I love this forum! :) :) :) :cool: ;) :)

Reply to this Message

EMCUE - 17 Jun 2006 02:10 GMT

I will be searching a range in at least two colums, so I can find
duplicates with the first and last names that match, so using the
typical conditional formating to find dups, I just end up with a bunch
of cells, which are contacts, that have the same first name, or last
name, or whatever in in single column I need to use a function that
will increase my range. any help there?

Signature

EMCUE

Reply to this Message

Peo Sjoblom - 17 Jun 2006 02:39 GMT

You can concatenate the cells in a third column, assume first name is A2 and
last B2

=A2&B2

copy down as long as needed
then do the duplicate tagging on the help column

If you need to create a list of those two columns without any duplicates I
would use data>filter advanced filter,
assume the header (you need headers for advanced filter) for the first names
start in A3 and the names in A4, the last names and header starts in B3

in E2 put

=SUMPRODUCT(--($A$4:A4&$B$4:B4=A4&B4))=1

now select the range from the header to the last data, do
data>filter>advanced filter, select copy to another location and as criteria
use

$E$1:$E$2

E1 needs to be blank

click OK

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

> I will be searching a range in at least two colums, so I can find
> duplicates with the first and last names that match, so using the
> typical conditional formating to find dups, I just end up with a bunch
> of cells, which are contacts, that have the same first name, or last
> name, or whatever in in single column I need to use a function that
> will increase my range. any help there?

Reply to this Message