I have a work book that gets updated daily, the only problem is it has duplicates going in and I have information put against certain items.

Is it possible to remove the duplicates based on C,E,H being identical? Column A is the date entered onto spreadsheet where I would need to leave the lastest info. Taking all that into account, if there are any comments in column I or J then those rows are to remain.

Sorry if I haven't made my self clear, I would post a mock speadsheet but don't know how.

Thanks in advance