I try to conditionally select rows from 3 groups.
I have a table that can be divided in 3 groups (defined by 3 values of column B) as shown in attachment.
I would need to find out the following: if group 1 (value '1G') appears, then if group 2 (value '3G') appears within 10 minutes, and then finally if group 3 (value '5G') appears within 20 minutes (counting from group 1 time).
The row results of the 3 groups would be written.
Please see attachment for an example of the source file.
Thank you for your help.
I have a table that can be divided in 3 groups (defined by 3 values of column B) as shown in attachment.
I would need to find out the following: if group 1 (value '1G') appears, then if group 2 (value '3G') appears within 10 minutes, and then finally if group 3 (value '5G') appears within 20 minutes (counting from group 1 time).
The row results of the 3 groups would be written.
Please see attachment for an example of the source file.
Thank you for your help.
