| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove duplicate rows based on 1 specific criterion
Question:
A B Apple 1/1/2004 Apple 2/1/2005 (to be deleted) Orange 1/1/2004 Orange 2/1/2005(to be deleted) Orange 3/1/2006(to be deleted) I want to delete the duplicate rows based on column A. The rows to keep will be the one with earliest date in column B. Appreciate any help. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Totals on Successive Rows Based on Two Criterion | Excel Discussion (Misc queries) | |||
| Delete rows that don't meet specific criterion | New Users to Excel | |||
| Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
| Insert duplicate rows based on numeric value in column | Excel Discussion (Misc queries) | |||
| Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
Threaded Mode
