Formula for multiple fields in the subset

[svergtanya]

Hi, I have a set of data, where I would like to check a time sequence of the events for the subset (id).
For example, 

for ID 1 I would like to check, that Event 71 happened before 72.

If the event didn't happen or in a wrong seq

ID	Timestamp	Event 1	Event 2
1	2020-01-01 10:00:00	71	Send
1	2020-01-01 10:01:00	72	Receive
1	2020-01-01 10:02:00	73	Convert
2	2020-01-01 10:00:00	71	Send
2	2020-01-01 10:01:00	73	Convert

[mbarone]

Once you sort your data in the applicable order (maybe ID then Event 1), you'd use a Multi-Row formula tool.  

[Emil_Kos]

Hi @svergtanya,

I think this should help you!

Output:

Please mark as a solution if this was something helpful!

[Emil_Kos · Accepted solution]

Hi @mbarone,

You aret otally right I forgot to add a sort tool!

[Emil_Kos]

Hi @svergtanya,

Happy to help.

Thank you for marking my position as an answer.

It is highly appreciated!

[svergtanya]

Thanks for your help! 

You saved me a lot of time and headache 🙂