which record is deleted when I use the "remove duplicates" functi.

A

amcellhinney

I want the oldest record to be deleted, not the newest when I find the same
customer - how can I ensure this happens?
 
S

ShaneDevenshire

Hi,

what does your data look like? How do you know which record is the oldest?
What if there are more than two records? Could you should us a sample data
layout?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

You'll need a new app to open this about link 1
Remove duplicates 2
Copy previous record into form field 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
Using a Date and corresponding weekday to pull amounts 1
Improving Macro That Keeps First Letter 0
Word doc keeps changing to ALL CAPS 0
Date Comparison in the same column 6

Top