Remove duplicates

J

jennifer

How do I get the oldest date instead of the newest date when using remove
duplicates?
 
O

Otto Moehrbach

Jennifer
How do the oldest and newest dates relate to "removing duplicates"?
Explain what you have and what you want to have. HTH Otto
 
S

Shane Devenshire

If you are using 2007 then sort decending by the date column and then choose
the remove duplicates command.
 

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

Removing a repeated words 0
How to sync OL365 contacts and calendar to iPhone without iTunes? 1
Repeated phrases wildcard? 1
Using a Date and corresponding weekday to pull amounts 1
Can XIRR Work on Dates That Move Backwards in Time? 3
which record is deleted when I use the "remove duplicates" functi. 1
changing a calculation in a pivot table 0
Countdown macro - display settings 2

Top