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


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

"EMCUE" <[email protected]> wrote in
message news:[email protected]...
>
> 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!
>
>
> --
> EMCUE
> ------------------------------------------------------------------------
> EMCUE's Profile:
> http://www.excelforum.com/member.php...o&userid=32945
> View this thread: http://www.excelforum.com/showthread...hreadid=552852
>

[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


"EMCUE" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
>
> --
> EMCUE
> ------------------------------------------------------------------------
> EMCUE's Profile:
> http://www.excelforum.com/member.php...o&userid=32945
> View this thread: http://www.excelforum.com/showthread...hreadid=552852
>