Can you give me a little more information on "but remove other dups" are you replying to removing the other columns or all the duplicates in Column A and still keep the other 5 columns with the correlated date?
Do you want this automated as in run a macro to do what you have you have describe above?
I can give you instructions on how to use the tools in excel to do what you have requested or I can create a macro that will complete the same task automatically. I have attached one with what you have asked for.
Go to the data tab in excel. There should be a button that says "remove duplicates". If it ask to expand selected just click ok. Click the button unselect all on the screen popup. Then put a check mark in the second box in the list then hit ok.