Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retaining the ONE most current dupe...
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
(redux) PasteSpecialValue doesnt dupe value exactly sometimes (!) | Excel Discussion (Misc queries) | |||
How do I de-dupe two columns of data in excel? | Excel Discussion (Misc queries) | |||
Why PasteSpecialValue doesnt always dupe binary value exactly? | Excel Discussion (Misc queries) | |||
De-Dupe Records Based on Two Fields. | Excel Discussion (Misc queries) | |||
how do i "de-dupe?" rows by a column value? | Excel Discussion (Misc queries) |