Retain most current dupe only??

[Guest]

Anybody know how I can delete multiple duplicate records (except one field is
unique- the time stamp) and only retain the most current one based on that
time stamp cell? Example:

ITEM | QTY | DESC | DATE | LOT
101 5 xxx 09/30/04 k5
101 5 xxx 09/29/04 k5
101 5 xxx 09/24/04 k5
101 5 xxx 09/12/04 k5

I only want to keep the most current record (I already sorted by that
column) and delete the rest. I could do this in Access or SQL if I knew the
specific logic to make it work. Any help would be greatly appreciated!!

~ Ralph

 

[Frank Kabel]

Hi
try the following array formula (entered with cTRL+SHIFT+ENTER) in F1
=IF(D1=MAX(IF(($A$1:$A$100=A1)*($B$1:$B$100=B1)*($C$1:$C$100=C1)*($E$1:
$E$100=E1),$D$1:$D$100)),"","X")
copy this down for all rows and filter with this new column. Delete all
'X' records