Group by Record ID

[DataKiller]

Hello everyone, 

    I need your help!

I added Record ID in a new column, and filtered by the conditions, then I got the file which I attached. you can see the record ID jump from 4 to 10, 13 to 20. so I would like to add a new column of ID to group of 1-4, 10-13,20-26

Record ID	Time	Speed
1	1	23
2	2	23
3	3	23
4	4	23
10	5	23
11	6	23
12	7	23
13	8	23
20	9	23
21	10	23
24	11	23
26	12	23

[jasperlch · Accepted solution]

Hi @DataKiller 

This could be achieved by adding a Multi-Row Formula to create a new group ID:

if [Record ID] = [Row-1:Record ID] + 1 then [Row-1:New Group ID] else [Row-1:New Group ID] + 1 endif

[DavidP · Accepted solution]

Hi @DataKiller 

I would use a multi-row formula, like this

[DataKiller]

Perfect!