Create a rank by group

[Sammy22]

hello,

i have the first 3 columns as below where i have a number for each product but i need to create the number based on which group it is in like in the 'new number' column.

Product	group	number	New number
23243	a	1	1
23244	a	2	2
23245	a	3	3
23246	a	4	4
23247	b	5	1
23248	b	6	2

[L_T]

@Sammy22 you could use a multi-row formula, grouping by "group"

[Felipe_Ribeir0 · Accepted solution]

Hi @Sammy22 

You can use the tile tool to do it automatically for you

[binuacs]

@Sammy22 similar to @L_T solution

[jpmoralesgar]

Thank you, it was very helpful :)