give the row number depending on a group number

[mark692]

i have 2 column, first column is where the group number is located the 2nd is where I want to put a formula thaw will give me the row number of the given number on the first column (example below). Is this possible? thanks

Book1
	A	B	C
1	name	Group	Row number per group
2		1	1
3		1	2
4		1	3
5		1	4
6		2	1
7		2	2
8		2	3
9		2	4
10		3	1
11		3	2
12		3	3
13		3	4
14		3	5
15		4	1
16		4	2
17		4	3
18		4	4
Sheet1

 

[sandy666]

name	Group		name	Group	RPG
	1			1	1
	1			1	2
	1			1	3
	1			1	4
	2			2	1
	2			2	2
	2			2	3
	2			2	4
	3			3	1
	3			3	2
	3			3	3
	3			3	4
	3			3	5
	4			4	1
	4			4	2
	4			4	3
	4			4	4

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"name", "Group"}, {{"Count", each Table.RowCount(_), type number}}),
    List = Table.AddColumn(Group, "RPG", each {1..[Count]}),
    Expand = Table.ExpandListColumn(List, "RPG"),
    RC = Table.RemoveColumns(Expand,{"Count"})
in
    RC

 

[sandy666]

or

Book2
	B	C	D
2	name	Group	RPG
3		1	1
4		1	2
5		1	3
6		1	4
7		2	1
8		2	2
9		2	3
10		2	4
11		3	1
12		3	2
13		3	3
14		3	4
15		3	5
16		4	1
17		4	2
18		4	3
19		4	4
Sheet1

Cell Formulas
Range	Formula
D3:D19	D3	=COUNTIF(C$3:C3,C3)