Serial No Based on the Group

[irfman]

Hi, I have a long list of data that is ranked based on the Group. Now I need a formula in column E and F to arrange numbering series for each Group (i.e. starting from 1 up to the maximum rank in each group). How is this possible through an excel formula. Any assistance in the matter will be much appreciated.

Regards

 

[mehidy1437]

try below...

group.xlsx
	A	B	C	D	E	F
1	A Group	B Value	c Rank	D	E Serial No	F Serial No
2	Old	856,385	1		Old	New
3	New	101,306	6		1	1
4	New	364,216	2		2	2
5	New	9,159	7		3	3
6	New	3,249,154	1		4	4
7	Old	499,980	3		5	5
8	Old	102,951	10		6	6
9	Old	217,834	6		7	7
10	Old	325,531	5		8
11	New	289,402	5		9
12	Old	153,511	8		10
13	New	316,572	4		11
14	New	320,446	3
15	Old	668,904	2
16	Old	115,243	9
17	Old	153,649	7
18	Old	357,973	4
19	Old	62,974	11
Table 1

Cell Formulas
Range	Formula
E3:E19	E3	=IF(ROWS(E$3:E3)<=(SUMPRODUCT(MAX(($A$2:$A$19=$E$2)*($C$2:$C$19)))),ROWS(E$3:E3),"")
F3:F19	F3	=IF(ROWS(E$3:E3)<=(SUMPRODUCT(MAX(($A$2:$A$19=$F$2)*($C$2:$C$19)))),ROWS(E$3:E3),"")

 

[irfman]

thanks bro, issue resolved

 

[mehidy1437]

You are welcome & thanks for the feedback