I am working on a robot which will have dynamic data coming in and I need to filter out anything that was not raised (in ‘Opened’ column on example) in the last month.
So if I ran it in December, it would pull out anything from November and remove the rest.
If I ran it in January, it would pull out December and so on.
I am having trouble working out how best to do this.
Can anyone help?
Test.xlsx (27.2 KB)