View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] annysjunkmail@tiscali.co.uk is offline
external usenet poster
 
Posts: 48
Default Remove duplicates from list but leaving one row with highest date

Hi Group,
I am trying to delete duplicate rows but leaving one row where it has
the highest date. For example, I have 250 records in my list but
manually removing duplicates I know that there are 175 unique records
based on most recent date. I need to do this task very often.
I have searched through previous postings but I can't find anything
that meets my needs - can somehelp?

Many thanks
Tony