Hello,

I am working with a table that is appended every day with new data. I would like to set up a macro that removes duplicate entries in column A (delete whole row) based on the age of the entry (remove oldest). The catch is I need the macro to ignore all "Departed" entries.

Attached a sample screenshot of my table.

Thanks for any input!

ErlendCapture.PNG