Delete articles/rows based on a given cutoff date?

Copper Contributor

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 

 

Bubblecup77_0-1677674503048.png

Br/ Robert

1 Reply

@Bubblecup77 

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 :)