Re: Excel Dupe macro

2010-06-02 Thread Ken Hoegeman 
Access comes with a find duplicates query wizard or just use a query with
the group by option and copy and paste to Excel

Ken

On Wed, Jun 2, 2010 at 12:55 PM, Joseph L. Casale  wrote:

>  @ Eric,
>
> Absolutely…
>
>
>
> @Ben,
> I haven’t used Access, and really don’t know sh!t about it, given this one
> time need I was hoping to avoid spending much time on itJ
>
>  *From:* Erik Goldoff [mailto:egold...@gmail.com]
> *Sent:* Wednesday, June 02, 2010 10:33 AM
>
> *To:* NT System Admin Issues
> *Subject:* RE: Excel Dupe macro
>
>
>
> I’d be interested in what you turn up if you don’t mind sharing
>
>
>
> Thanks
>
>
>
> *Erik Goldoff***
>
> *IT  Consultant*
>
> *Systems, Networks, & Security *
>
> '  Security is an ongoing process, not a one time event ! '
>
> *From:* Joseph L. Casale [mailto:jcas...@activenetwerx.com]
> *Sent:* Wednesday, June 02, 2010 12:11 PM
> *To:* NT System Admin Issues
> *Subject:* Excel Dupe macro
>
>
>
> Hey guys,
> I have a guy who was using some unknown software on his laptop that he no
> longer has admin right to that bollixed up his contacts in OL.
>
> So, he has ~7400 now and prolly only ~500 are valid. The issue with using
> tools of my choice to fix this are the few fields that contain odd
> characters, so I am trying to do it in excel.
>
> I found a macro to check dupes (the built in sort method crashes excel) but
> its removing some amount of contacts completely?
>
>
>
> Anyone got a robust macro for excel that can remove duplicate records in
> large datasets?
>
>
>
> Thanks!
> jlc
>
>
>
>
>
>
>
>
>
>
>
>
>
>

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

RE: Excel Dupe macro

2010-06-02 Thread Ken Schaefer 
It's really simple to find duplicate records using SQL.

Excel - not so easy

Cheers
Ken

From: Joseph L. Casale [mailto:jcas...@activenetwerx.com]
Sent: Thursday, 3 June 2010 12:56 AM
To: NT System Admin Issues
Subject: RE: Excel Dupe macro

@ Eric,
Absolutely...

@Ben,
I haven't used Access, and really don't know sh!t about it, given this one time 
need I was hoping to avoid spending much time on it:)
From: Erik Goldoff [mailto:egold...@gmail.com]
Sent: Wednesday, June 02, 2010 10:33 AM
To: NT System Admin Issues
Subject: RE: Excel Dupe macro

I'd be interested in what you turn up if you don't mind sharing

Thanks

Erik Goldoff
IT  Consultant
Systems, Networks, & Security
'  Security is an ongoing process, not a one time event ! '
From: Joseph L. Casale [mailto:jcas...@activenetwerx.com]
Sent: Wednesday, June 02, 2010 12:11 PM
To: NT System Admin Issues
Subject: Excel Dupe macro

Hey guys,
I have a guy who was using some unknown software on his laptop that he no 
longer has admin right to that bollixed up his contacts in OL.
So, he has ~7400 now and prolly only ~500 are valid. The issue with using tools 
of my choice to fix this are the few fields that contain odd characters, so I 
am trying to do it in excel.
I found a macro to check dupes (the built in sort method crashes excel) but its 
removing some amount of contacts completely?

Anyone got a robust macro for excel that can remove duplicate records in large 
datasets?

Thanks!
jlc













~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

Re: Excel Dupe macro

2010-06-02 Thread James Edwards 
Try www.mrexcel.com
The Forums.

Jim

On 6/2/10 9:11 AM, Joseph L. Casale wrote:
>
> Hey guys,
> I have a guy who was using some unknown software on his laptop that he 
> no longer has admin right to that bollixed up his contacts in OL.
>
> So, he has ~7400 now and prolly only ~500 are valid. The issue with 
> using tools of my choice to fix this are the few fields that contain 
> odd characters, so I am trying to do it in excel.
>
> I found a macro to check dupes (the built in sort method crashes 
> excel) but its removing some amount of contacts completely?
>
> Anyone got a robust macro for excel that can remove duplicate records 
> in large datasets?
>
> Thanks!
> jlc
>
>   


~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

Re: Excel Dupe macro

2010-06-02 Thread Ben Scott 
On Wed, Jun 2, 2010 at 12:55 PM, Joseph L. Casale
 wrote:
> I haven’t used Access, and really don’t know sh!t about it, given this one
> time need I was hoping to avoid spending much time on itJ

  Fair enough, but for purposes of the current problem, you can just
treat an Access table as a really big spreadsheet.  :)

-- Ben

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

RE: Excel Dupe macro

2010-06-02 Thread Joseph L. Casale 
@ Eric,
Absolutely...

@Ben,
I haven't used Access, and really don't know sh!t about it, given this one time 
need I was hoping to avoid spending much time on it:)

From: Erik Goldoff [mailto:egold...@gmail.com]
Sent: Wednesday, June 02, 2010 10:33 AM
To: NT System Admin Issues
Subject: RE: Excel Dupe macro

I'd be interested in what you turn up if you don't mind sharing

Thanks

Erik Goldoff
IT  Consultant
Systems, Networks, & Security
'  Security is an ongoing process, not a one time event ! '
From: Joseph L. Casale [mailto:jcas...@activenetwerx.com]
Sent: Wednesday, June 02, 2010 12:11 PM
To: NT System Admin Issues
Subject: Excel Dupe macro

Hey guys,
I have a guy who was using some unknown software on his laptop that he no 
longer has admin right to that bollixed up his contacts in OL.
So, he has ~7400 now and prolly only ~500 are valid. The issue with using tools 
of my choice to fix this are the few fields that contain odd characters, so I 
am trying to do it in excel.
I found a macro to check dupes (the built in sort method crashes excel) but its 
removing some amount of contacts completely?

Anyone got a robust macro for excel that can remove duplicate records in large 
datasets?

Thanks!
jlc









~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

Re: Excel Dupe macro

2010-06-02 Thread Ben Scott 
On Wed, Jun 2, 2010 at 12:11 PM, Joseph L. Casale
 wrote:
> Anyone got a robust macro for excel that can remove duplicate records in
> large datasets?

  Have you tried Access?  You really don't want to be using a
spreadsheet for a large dataset.

-- Ben

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

RE: Excel Dupe macro

2010-06-02 Thread Erik Goldoff 
I’d be interested in what you turn up if you don’t mind sharing

 

Thanks

 

Erik Goldoff

IT  Consultant

Systems, Networks, & Security 

'  Security is an ongoing process, not a one time event ! '

From: Joseph L. Casale [mailto:jcas...@activenetwerx.com] 
Sent: Wednesday, June 02, 2010 12:11 PM
To: NT System Admin Issues
Subject: Excel Dupe macro

 

Hey guys,
I have a guy who was using some unknown software on his laptop that he no
longer has admin right to that bollixed up his contacts in OL.

So, he has ~7400 now and prolly only ~500 are valid. The issue with using
tools of my choice to fix this are the few fields that contain odd
characters, so I am trying to do it in excel.

I found a macro to check dupes (the built in sort method crashes excel) but
its removing some amount of contacts completely?

 

Anyone got a robust macro for excel that can remove duplicate records in
large datasets?

 

Thanks!
jlc

 

 

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~