Ranking based on ID and Date Time

[zealisk]

Hi everyone,

I have the following data set sorted by ID and Date Time

Sometimes the ownership changes in the same hour and time.

ID	Old Owner	New Owner	Date Time
1	Richard	John	2021-11-11 10:02
1	John	Jane	2021-11-11 11:50
1	Miranda	Jane	2021-11-11 11:50
1	Jane	Miranda	2021-11-11 11:50
1	Jane	Miranda	2021-11-11 11:50
2	Raul	Ricardo	2023-05-02 12:23
2	Bobby	Nila	2023-05-02 16:36
2	Ricardo	Bobby	2023-05-02 16:36

I need to rank them based on ID so the output is as follows:

ID	Old Owner	New Owner	Date Time	Rank
1	Richard	John	2021-11-11 10:02	1
1	John	Jane	2021-11-11 11:50	2
1	Miranda	Jane	2021-11-11 11:50	4
1	Jane	Miranda	2021-11-11 11:50	3
1	Jane	Miranda	2021-11-11 11:50	5
2	Raul	Ricardo	2023-05-02 12:23	1
2	Bobby	Nila	2023-05-02 16:36	3
2	Ricardo	Bobby	2023-05-02 16:36	2

I was able to do it for ID 2 with multi-row formula.

I'm not able to figure out ID 1

[Luke_C]

@zealisk What's the logic in the case of the time being the same? 

Generally you could sort and either use a multi row or tile tool to assign, grouping by ID.

[zealisk]

Hi Luke,

There's another data set with actions and I need to know who made those actions based on who was the Owner at that time. \

So for example, an action for ID 1 that occured in 2021-11-11 14:52 is done by Miranda.

I hope that makes sense