Ranking Formula Required

[mikemcbain]

In the mini sheet below (hope it works my first time trying XL2BB) I require a formula in ColAA which ranks any Rows that are identical in Col's A,B,D,E,F and G. There can be up to 6 rows that may qualify and I would like non-qualifiers to show Blank in AA.

With thanks
Old Mike.

TestMagic.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
7	DATE	TIME	REF	NAME	CTRY	RACE	DIST	GRADE	No.	SURNAME	VOL%	VOL2%	RATE	RATED	RORANK	RATVOL	RATVOL2	RVRANK	RANK	VALUE	OUT	VALU	WL	PL			RANKED
8	04/01/2021	00:08	TEST #7731	Grace	GB	A6	415		4		15.9	15.9	118	118	3	1064	1064	2		5.30	5.00	5.30	L	-5.00
9	04/01/2021	00:27	TEST #7751	Timothy	GB	D2	261		5		23.1	23.1	196	196	1	990	990	2		4.80	5.00	4.80	L	-5.00
10	04/01/2021	00:32	TEST #7753	Angel	GB	B3	450		2		22.8	22.8	111	111	3	1084	1084	3	1	4.40	5.00	4.40	W	17.00
11	04/01/2021	00:38	TEST #7756	Grace	GB	A7	415		2		21.2	21.2	60	60	3	764	764	6		4.40	5.00	4.40	L	-5.00
12	04/01/2021	00:43	TEST #7763	Timothy	GB	A1	450		4		13.8	13.8	29	29	5	895	895	4		5.40	5.00	5.40	L	-5.00
13	04/01/2021	00:58	TEST #7772	Timothy	GB	A3	450		2		13.0	13.0	117	117	2	805	805	4	1	4.80	5.00	4.80	W	19.00
14	04/01/2021	01:03	TEST #7776	Simon	GB	A6	462		1		9.1	9.1	141	141	2	1036	1036	3	1	5.40	5.00	5.40	W	22.00			1
15	04/01/2021	01:03	TEST #7777	Simon	GB	A6	462		2		10.0	10.0	69	69	3	942	942	4		5.50	5.00	5.50	L	-5.00			2
16	04/01/2021	01:53	TEST #7806	Simon	GB	A2	462		2		16.0	16.0	150	150	2	799	799	3		5.40	5.00	5.40	L	-5.00			1
17	04/01/2021	01:53	TEST #7807	Simon	GB	A2	462		4		35.1	35.1	182	182	1	919	919	1		4.80	5.00	4.80	L	-5.00			2
18	04/01/2021	02:08	TEST #7810	Simon	GB	A3	462		3		22.4	22.4	27	27	5	836	836	3		5.40	5.00	5.40	L	-5.00
19	04/01/2021	02:25	TEST #7817	Simon	GB	HC	650		1		26.1	26.1	155	155	2	827	827	2	1	4.70	5.00	4.70	W	18.50			1
20	04/01/2021	02:25	TEST #7818	Simon	GB	HC	650		2		19.6	19.6	286	286	1	798	798	3		5.10	5.00	5.10	L	-5.00			2
21	04/01/2021	02:25	TEST #7820	Simon	GB	HC	650		4		13.1	13.1	88	88	4	688	688	5		5.10	5.00	5.10	L	-5.00			3
22	04/01/2021	02:25	TEST #7821	Simon	GB	HC	650		5		12.3	12.3	24	24	5	788	788	4		6.00	5.00	6.00	L	-5.00			4
23	04/01/2021	03:03	TEST #7839	Simon	GB	D4	268		3		6.4	6.4	109	109	3	817	817	3	1	5.50	5.00	5.50	W	22.50
24	04/01/2021	03:22	TEST #7849	Simon	GB	A4	462		4		10.7	10.7	30	30	5	830	830	3		6.00	5.00	6.00	L	-5.00			1
25	04/01/2021	03:22	TEST #7851	Simon	GB	A4	462		6		12.6	12.6	242	242	1	902	902	1		6.00	5.00	6.00	L	-5.00			2
26	04/01/2021	03:42	TEST #7862	Simon	GB	A2	462		6		25.5	25.5	96	96	3	721	721	2		4.30	5.00	4.30	L	-5.00
27	04/01/2021	04:02	TEST #7867	Simon	GB	D1	268		1		18.9	18.9	135	135	2	811	811	1	1	5.70	5.00	5.70	W	23.50			1
28	04/01/2021	04:02	TEST #7871	Simon	GB	D1	268		5		18.4	18.4	14	14	5	573	573	4		5.40	5.00	5.40	L	-5.00			2
29	04/01/2021	05:16	TEST #7900	Paul	GB	A10	460		2		17.0	17.0	125	125	1	1044	1044	1		5.00	5.00	5.00	L	-5.00			1
30	04/01/2021	05:16	TEST #7901	Paul	GB	A10	460		3		21.0	21.0	78	78	4	998	998	2		5.80	5.00	5.80	L	-5.00			2
31	04/01/2021	05:16	TEST #7903	Paul	GB	A10	460		5		11.2	11.2	119	119	2	853	853	3		5.70	5.00	5.70	L	-5.00			3
32	04/01/2021	05:18	TEST #7906	Eunice	GB	A3	476		2		20.3	20.3	107	107	2	884	884	4		5.40	5.00	5.40	L	-5.00
33	04/01/2021	05:27	TEST #7914	Harper	GB	D1	265		4		22.8	22.8	20	20	5	665	665	6	1	4.70	5.00	4.70	W	18.50
34	04/01/2021	05:32	TEST #7917	Paul	GB	A9	460		2		23.3	23.3	99	99	3	956	956	4		4.70	5.00	4.70	L	-5.00
Sheet1

 

[alz]

Try This!

=IF(COUNTIFS($A$2:$A$28,A2,$B$2:$B$28,B2,$D$2:$D$28,D2,$E$2:$E$28,E2,$F$2:$F$28,F2,$G$2:$G$28,G2)>1,COUNTIFS($A$2:A2,A2,$B$2:B2,B2,$D$2:D2,D2,$E$2:E2,E2,$F$2:F2,F2,$G$2:G2,G2),"")

 

[mikemcbain]

Try This!

=IF(COUNTIFS($A$2:$A$28,A2,$B$2:$B$28,B2,$D$2:$D$28,D2,$E$2:$E$28,E2,$F$2:$F$28,F2,$G$2:$G$28,G2)>1,COUNTIFS($A$2:A2,A2,$B$2:B2,B2,$D$2:D2,D2,$E$2:E2,E2,$F$2:F2,F2,$G$2:G2,G2),"")

Truly Magic Alz much appreciated and can't believe how much knowledge and goodwill is ever present on this Forum

Mike.

 

[alz]

Thanks For the feedback.!

I am also learning so much from this forum.