Excel Ranking Formula with Unique Records

[amkkhan]

I want top 3 Unique students ranking filtered from records below along with their details
and all the other roll numbers excluding the ones that are once already mentioned once in the left
Only that appeared on top 3 in the last column (with Comma separation)

Class Data - Copy.xlsm
	D
11	25
1st

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A8:I20,J11:N20	Cell	contains a blank value	text	NO
D11:D20,F11:F20,H11:H20	Cell Value	<10	text	NO

 

[ExceLoki]

The xl2bb you shared only has one cell. I'm assuming you meant to share more?

 

[amkkhan]

The xl2bb you shared only has one cell. I'm assuming you meant to share more?

Yup... You are right

Class Data - Copy.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1		POSITION HOLDERS :
2
3	Sr.No	Position	Roll. No :		Name :				T. Marks		Obtained		%age		Other Position Holders
4	1	1st	1		Abdullah Malik				75		75		100.00		1 , 4 , 7
5	2	2nd	1		Abdullah Malik				75		75		100.00		2 , 5 , 8
6	3	3rd	1		Abdullah Malik				75		75		100.00		3 , 6 , 9
7
8	Roll. No :	Adm. No :	Name :	T.Name		T.Name		T.Name		T. Marks	Total			Merit
9				Sub-1		Sub-2		Sub-3			Marks
10				Marks	Grade	Marks	Grade	Marks	Grade		Marks	%age	Grade
11	1	1529	Abdullah Malik	25	A+	25	A+	25	A+	75	75	100.00	A+	1st
12	2	1565	Mohsin Hayat	24	D	24	D	24	D	75	72	96.00	D	2nd
13	3	1602	Hafeez Ullah	23	D	23	D	23	F	75	69	92.00	F	3rd
14	4	1656	Ahsan Khan	25	D	25	D	25	F	75	75	100.00	F	1st
15	5	1660	Asif	24		24	D	24		75	72	96.00	F	2nd
16	6	1663	Alyan Abbas	23		23	D	23	A+	75	69	92.00	D	3rd
17	7	1680	Syed Shujaat	25	F	25	D	25	F	75	75	100.00	F	1st
18	8	1681	M. Haseeb	24	A+	24	A+	24	A+	75	72	96.00	A+	2nd
19	9	1684	M. Anns	23	A+	23	A+	23	A+	75	69	92.00	A+	3rd
20	10	1686	Ahmad Hassan	22	A+	22	A+	22	A+	75	66	88.00	A+	4th
1st

Cell Formulas
Range	Formula
C3	C3	=IF('D:\FG School\Result Software\Finalization\Result Compilation - New Changes\[Classes Prep.xlsm]Award List'!A4="","",'D:\FG School\Result Software\Finalization\Result Compilation - New Changes\[Classes Prep.xlsm]Award List'!A4)
E3	E3	='D:\FG School\Result Software\Finalization\Result Compilation - New Changes\[Classes Prep.xlsm]Award List'!C4
I3	I3	=IF('D:\FG School\Result Software\Finalization\Result Compilation - New Changes\[Classes Prep.xlsm]Award List'!E2="","",'D:\FG School\Result Software\Finalization\Result Compilation - New Changes\[Classes Prep.xlsm]Award List'!E2)
M3	M3	=IF('D:\FG School\Result Software\Finalization\Result Compilation - New Changes\[Classes Prep.xlsm]Award List'!E4="","",'D:\FG School\Result Software\Finalization\Result Compilation - New Changes\[Classes Prep.xlsm]Award List'!E4)
C4	C4	=INDEX($A$11:$A$20,MATCH(SMALL(N11:N20,1),N11:N20,0),0)
E4	E4	=INDEX($C$11:$C$20,MATCH(SMALL(N11:N20,1),N11:N20,0),0)
C5	C5	=INDEX($A$11:$A$20,MATCH(SMALL(N11:N20,2),N11:N20,0),0)
E5	E5	=INDEX($C$11:$C$20,MATCH(SMALL(N11:N20,2),N11:N20,0),0)
C6	C6	=INDEX($A$11:$A$20,MATCH(SMALL(N11:N20,3),N11:N20,0),0)
E6	E6	=INDEX($C$11:$C$20,MATCH(SMALL(N11:N20,3),N11:N20,0),0)
K4	K4	=INDEX($K$11:$K$20,MATCH(SMALL(N11:N20,1),N11:N20,0),0)
M4:M6	M4	=IF(I4="","",(K4/I4)*100)
O4:O6	O4	=TEXTJOIN(" , ",TRUE,IF(A4=$N$11:$N$20,$A$11:$A$20,""))
K5	K5	=INDEX($K$11:$K$20,MATCH(SMALL(N11:N20,2),N11:N20,0),0)
K6	K6	=INDEX($K$11:$K$20,MATCH(SMALL(N11:N20,3),N11:N20,0),0)
K11:K20	K11	=SUM(D11,F11,H11)
L11:L20	L11	=K11/J11*100
N11:N20	N11	=IF(K11="","",SUMPRODUCT((K11<=$K$11:$K$20)/COUNTIF($K$11:$K$20,$K$11:$K$20)))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O4:O6	Cell	contains a blank value	text	NO
O4:O6	Cell	contains a blank value	text	NO
O3	Cell	contains a blank value	text	NO
A3:N6	Cell	contains a blank value	text	NO
C4:E6,I4:N6	Cell	contains a blank value	text	NO
K10:M10	Cell	contains a blank value	text	NO
A8:I20,J11:N20	Cell	contains a blank value	text	NO
D11:D20,F11:F20,H11:H20	Cell Value	<10	text	NO
N8,K8:K9,J8:J10	Cell	contains a blank value	text	NO
N11:N20	Cell Value	duplicates	text	NO
N11:N20	Expression	=AND(N11>=44,N11<=50)	text	NO
N11:N20	Expression	=AND(N11>=34,N11<=40)	text	NO
N11:N20	Expression	=AND(N11>=24,N11<=30)	text	NO
N11:N20	Expression	=AND(N11>=4,N11<=20)	text	NO
N11:N20	Expression	=N11=43	text	NO
N11:N20	Expression	=N11=42	text	NO
N11:N20	Expression	=N11=41	text	NO
N11:N20	Expression	=N11=33	text	NO
N11:N20	Expression	=N11=32	text	NO
N11:N20	Expression	=N11=31	text	NO
N11:N20	Expression	=N11=23	text	NO
N11:N20	Expression	=N11=22	text	NO
N11:N20	Expression	=N11=21	text	NO
N11:N20	Expression	=N11=3	text	NO
N11:N20	Expression	=N11=2	text	NO
N11:N20	Expression	=N11=1	text	NO