Eliminating Duplicate records

[Andrew Wilson]

Hello,
firstly let me say i am a complete newbie to posting in forums although i have used them often to point me in the right direction.

I Have an excel 2007 table that gets updated every time a user adds or amends a record in a database even if they only press save. i need to count the entries by each user to compare to another figure but to do this reliably i need to exclude those records that don't really contain any useful data i.e. user pressed save more that once for some reason.

i have columns for User, Update Date-Time, Enquiry Id, among others

so the logic would be; remove rows where user ID and Enquiry Id are the same and the difference in Update Date-Time is less than 5 minutes.

i have some knowledge of VBA although would prefer a solution that does not use it as this needs to be used by non VBA trained Staff.

any help would be great
thanks in advance

 

[hurgadion]

Instead of the macro Eliminator try running the Code Eliminatorx. In my WorkSheet works it fine, when I run the new Code, best regards.

 

[Andrew Wilson]

Doh!,

yes it does work now , now all i need to do is expand it to include 12 columns of data, how do i do that?

a few comments on what the code is doing as well so i can try and learn this method for my self would be very good.

thank you very much for your help

 

[hurgadion]

Give me, please, an example with 12 Columns and an expected result, best regards.