I have data that I want to purge if the date is older than one year. The date value is in column H. Here's a logical (sort of) depiction of what i want done:This looks at data in the first row, sees if it is older than one year, and deletes it, shifting rows up. Then repeat until cell H15 is within one year.Please Login or Register to view this content.
Bookmarks