I love this forum! need help again!

[EMCUE]

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!

 

[Bernard Liengme]

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

 

[EMCUE]

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?

 

[Peo Sjoblom]

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

--

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