Ranking within hierarchy (=RANKIF)... using CHILDR

	Category	Hierarchy	Value	Rank without Helper	Rank 1	Rank 2	Rank 3	Rank with Helper	Helper
	Collaboration powered by Smartsheet   |   Report Abuse
1	a	1	20	1	1			1
2	b	2	16	1		1		1	a
3	c	3	5	2			2	2	b
4	d	3	8	1			1	1	b
5	e	3	3	3			3	3	b
6	f	2	1	3		3		3	a
7	g	2	3	2		2		2	a
8	h	1	6	2	2			2
9	i	2	1	3		3		3	h
10	j	2	2	2		2		2	h
11	k	2	3	1		1		1	h
12
13					for illustration, not needed	for illustration, not needed	for illustration, not needed
14		=COUNT(ANCESTORS (Category@row)) + 1		=RANKEQ(Value@row, COLLECT(Value:Value, Hierarchy:Hierarchy, Hierarchy@row, Helper:Helper, Helper@row), 0)	=IF($Hierarchy@row = 1, $[Rank without Helper]@row, "")	=IF($Hierarchy@row = 2, $[Rank without Helper]@row, "")	=IF($Hierarchy@row = 3, $[Rank without Helper]@row, "")	=RANKEQ(Value@row, COLLECT(Value:Value, Hierarchy:Hierarchy, Hierarchy@row, Helper:Helper, Helper@row), 0)	=PARENT(Category@row)