Formula that Removes duplicates as more date is inputed

Here is some code that will delete duplicates. It is currently set to run when ordered by selecting the macro. You could take this and put it in a workbook event, perhaps Before Close or Before Save and then it would automatically.

Please Login or Register  to view this content.

Nothing that comes to mind for me. Perhaps one of the Smart Guys here has a better solution.

Try this array entered formula in G7 of this example and fill down.

=IF(OR($G$6:G6=MAX($E$7:$E$12)),"",MIN(IF($E$7:$E$12>G6,$E$7:$E$12)))

If you aren’t familiar with array-entered formulas array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

You'll likely want a Dynamic Named (shrink and grow) Range to replace E7:E12 as new data is added.

Row\Col	E	F	G	H
7	8/11/2015	apple	8/11/2015	In G7 {=IF(OR($G$6:G6=MAX($E$7:$E$12)),"",MIN(IF($E$7:$E$12>G6,$E$7:$E$12)))}
8	8/11/2015	corn	8/14/2015
9	8/11/2015	corn	8/15/2015
10	8/14/2015	car
11	8/15/2015	apple
12	8/15/2015	apple

Here's another that doesn't require array entry and unlike the previous can be started in row 1.

=IFERROR(SMALL(IF(FREQUENCY($E$7:$E$12,$E$7:$E$12),$E$7:$E$12),ROWS($1:1)),"")