Forum Discussion
Bubblecup77
Mar 01, 2023Copper Contributor
Delete articles/rows based on a given cutoff date?
Hello, I'm working with a file that contains several items/articles where there have been price increases several times in many cases.
I would like to delete all items that have had a price increase before and include a certain date just say 2022.10.10 so that the file only contains newer price increases.
What would be the easiest way to do this? Is there a way to put the date in a cell and it will automatically delete all items that have not had a price change after this date?
example
Br/ Robert
- NikolinoDEGold Contributor
Here is a small example where you can enter the date manually and all lines up to that date will be deleted.
Don't know exactly if this helps with filter...but who knows, maybe it will help you 🙂