Filtering data into different tables based on conditions
Hi all,
I have a table with rows of data relating to tasks. Using the following example below I have a few outcomes that I would like but I am unsure of the best way to do that, so open to suggestions
I want to create three tables effectively.
One where RO:Plan Review is present, and with 14 days, there is also an RT:Pre Tmt Chk present. if those conditions are met then it takes the entire row.
the 2nd table would be the same except it looks for the RT:Pre Tmt Check Replan, that is within 2 weeks of the RO:Plan Review.
The final table would be when there is an RO:Plan Review present, but no RT:Pre Tmt Chk, or RT:Pre Tmt Check Replan within 2 weeks.
sorry if that is super confusing. Hope you can help and thanks in advance