I have a list of symbols (in column A) in an Excel spreadsheet with dates next to them (column B). (see attached file) Some of these symbols are repeated within a 7 day period. I would like a VB code that would delete THE WHOLE ROW of any symbol that has been repeated again within a 7 day period. For instance if it has been written on 7/2/04 and then again on 7/8/04 then the whole row of the second one has to be deleted. I would also like a code for a 14 day period. Anyone with relatively simple experience in VB code should do be able to do this in a few minutes.
P.S. i will not be paying more than 15 dollars for this.