Top 10 score from each column with Statement

[sksanjeev786]

Hi Team,

Can I get the top 10 scores from each column with Statements from B-E and just want to check if we get the statement color that would be great

Gen Z Chapter 2 Chart File_SCM-Batch 10.xlsm
	A	B	C	D	E
11		Gen Z	Millennials	Gen X	Boomers
12	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	76%	66%	68%	69%
13	Mental Health Days Off	75%	65%	63%	58%
14	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	73%	65%	70%	68%
15	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	71%	61%	70%	74%
16	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	70%	66%	66%	76%
17	Summer Hours (e.g., Half-day(s) Off Per Week During The Summer)	68%	64%	62%	61%
18	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	67%	69%	63%	67%
19	Fun Perks (Fun Perks (e.g., GrubHub Points, Dogs at Work, Event Tickets)	67%	58%	48%	43%
20	Rotation Programs to Explore/Try Different Roles	64%	59%	60%	58%
21	Stress Or Mindfulness Programs	64%	56%	55%	46%
22	Allowing Personal Interest/passion Projects Into Work	64%	56%	52%	47%
23	Working Remotely	64%	55%	60%	61%
24	Programs Allowing Managers To Reward Direct Reports w/Spot Bonuses, Etc.	63%	66%	63%	62%
25	Long-term Incentives (e.g., Stock Awards)	63%	64%	66%	79%
26	Career/Personal Training (Coaching, Leadership Dev.)	63%	63%	55%	64%
27	Hybrid Work Model (remote + In-office)	63%	61%	62%	62%
28	Tuition Reimbursement Programs	63%	55%	48%	50%
29	Paid Parental Leave (beyond 12 Weeks)	63%	54%	44%	33%
30	Four-day Work Week (i.e., 40 Hours Over 4 Days)	62%	61%	68%	63%
31	Communicating Corporate Responsibility POV to Employees	62%	61%	61%	65%
32	Student Loan Repayment Program	61%	62%	42%	29%
33	Onsite Access To Cafeterias And Restaurants	61%	57%	55%	43%
34	Actively Supporting Social Justice Causes	61%	54%	44%	34%
35	Measurable Diversity/ Equity/Inclusion Goals & Progress	61%	52%	47%	47%
36	Part Time Work And Job-sharing Options	60%	62%	53%	51%
37	Communication About Policies, Diversity, And/or Inclusion	60%	56%	52%	56%
38	E-learning & Self-guided Tools to Learn at My Own Pace	60%	51%	54%	59%
39	Recognition Programs (i.e., Employees Can Send/Receive Points For Award Redemption)	59%	66%	60%	59%
40	Enabling Employees to Get Involved (i.e., Volunteer Hours For Employees To Use)	59%	52%	55%	47%
41	On-site Preventive Care (e.g., Flu Shots, Health Screenings, Etc.)	59%	52%	46%	63%
42	Ongoing 'Safe Space' Forum For Open Dialogue & Discussion	58%	54%	51%	51%
43	On-site Gyms Or Gym Membership Discounts	57%	62%	40%	45%
44	Mentorship Programs	57%	56%	49%	53%
45	Different Forms Of Paycheck Payment (e.g., Direct Deposit, Cryptocurrency, Etc.)	57%	56%	41%	40%
46	Ensures Workforce Profile Adheres To Diversity Standards	57%	55%	46%	46%
47	Publicly Communicating Corporate Responsibility POV	56%	58%	53%	49%
48	Creating Diversity & Inclusion Groups Within Company	56%	55%	43%	40%
49	Recruitment/Hiring That Fosters Diversity & Inclusion	56%	54%	46%	47%
50	On-site Childcare Or Overnight Care	54%	55%	35%	27%
51	Forum to Learn About Employees' Different Backgrounds	53%	54%	42%	37%
52	Programs/Training for Inclusion & Diversity Groups In Leadership Roles	53%	49%	37%	28%
53	Digital Wallet	53%	47%	42%	41%
54	Exercise Programs/challenges	52%	54%	43%	44%
55	Family Planning (ex. Adoption, Surrogacy, Egg-freezing, Etc.)	50%	53%	27%	22%
56	Senior/parent Care	50%	45%	46%	40%
57	Financial Seminars	44%	52%	45%	29%
IncreasesDesire

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B12:B57	Other Type	Color scale		NO

 

[BSALV]

the top 10 without color

Map1
	A	B	C	D	E	F	G	H	I	J
1		Gen Z	Millennials	Gen X	Boomers			Millennials	Gen X	Boomers
2	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	76,00%	66,00%	68,00%	69,00%			Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	Long-term Incentives (e.g., Stock Awards)
3	Mental Health Days Off	75,00%	65,00%	63,00%	58,00%			Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)
4	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	73,00%	65,00%	70,00%	68,00%			Committed To Changing Company Policies/Practices (listening To Employees, Unions)	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)
5	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	71,00%	61,00%	70,00%	74,00%			Recognition Programs (i.e., Employees Can Send/Receive Points For Award Redemption)	Four-day Work Week (i.e., 40 Hours Over 4 Days)	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)
6	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	70,00%	66,00%	66,00%	76,00%			Mental Health Days Off	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	Communicating Corporate Responsibility POV to Employees
7	Summer Hours (e.g., Half-day(s) Off Per Week During The Summer)	68,00%	64,00%	62,00%	61,00%			Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	Long-term Incentives (e.g., Stock Awards)	Working Remotely
8	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	67,00%	69,00%	63,00%	67,00%			On-site Gyms Or Gym Membership Discounts	Mental Health Days Off	E-learning & Self-guided Tools to Learn at My Own Pace
9	Fun Perks (Fun Perks (e.g., GrubHub Points, Dogs at Work, Event Tickets)	67,00%	58,00%	48,00%	43,00%			Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	Rotation Programs to Explore/Try Different Roles	Communication About Policies, Diversity, And/or Inclusion
10	Rotation Programs to Explore/Try Different Roles	64,00%	59,00%	60,00%	58,00%			Hybrid Work Model (remote + In-office)	Working Remotely	Mentorship Programs
11	Stress Or Mindfulness Programs	64,00%	56,00%	55,00%	46,00%			Tuition Reimbursement Programs	Stress Or Mindfulness Programs	Ensures Workforce Profile Adheres To Diversity Standards
12	Allowing Personal Interest/passion Projects Into Work	64,00%	56,00%	52,00%	47,00%				Enabling Employees to Get Involved (i.e., Volunteer Hours For Employees To Use)
Blad1

Cell Formulas
Range	Formula
H2:H11,J2:J11,I2:I12	H2	=FILTER(SORTBY($A$2:$A$47,C2:C47,-1),C2:C47>=LARGE(C2:C47,10))
Dynamic array formulas.

 

[sksanjeev786]

the top 10 without color

Map1
	A	B	C	D	E	F	G	H	I	J
1		Gen Z	Millennials	Gen X	Boomers			Millennials	Gen X	Boomers
2	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	76,00%	66,00%	68,00%	69,00%			Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	Long-term Incentives (e.g., Stock Awards)
3	Mental Health Days Off	75,00%	65,00%	63,00%	58,00%			Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)
4	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	73,00%	65,00%	70,00%	68,00%			Committed To Changing Company Policies/Practices (listening To Employees, Unions)	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)
5	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	71,00%	61,00%	70,00%	74,00%			Recognition Programs (i.e., Employees Can Send/Receive Points For Award Redemption)	Four-day Work Week (i.e., 40 Hours Over 4 Days)	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)
6	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	70,00%	66,00%	66,00%	76,00%			Mental Health Days Off	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	Communicating Corporate Responsibility POV to Employees
7	Summer Hours (e.g., Half-day(s) Off Per Week During The Summer)	68,00%	64,00%	62,00%	61,00%			Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	Long-term Incentives (e.g., Stock Awards)	Working Remotely
8	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	67,00%	69,00%	63,00%	67,00%			On-site Gyms Or Gym Membership Discounts	Mental Health Days Off	E-learning & Self-guided Tools to Learn at My Own Pace
9	Fun Perks (Fun Perks (e.g., GrubHub Points, Dogs at Work, Event Tickets)	67,00%	58,00%	48,00%	43,00%			Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	Rotation Programs to Explore/Try Different Roles	Communication About Policies, Diversity, And/or Inclusion
10	Rotation Programs to Explore/Try Different Roles	64,00%	59,00%	60,00%	58,00%			Hybrid Work Model (remote + In-office)	Working Remotely	Mentorship Programs
11	Stress Or Mindfulness Programs	64,00%	56,00%	55,00%	46,00%			Tuition Reimbursement Programs	Stress Or Mindfulness Programs	Ensures Workforce Profile Adheres To Diversity Standards
12	Allowing Personal Interest/passion Projects Into Work	64,00%	56,00%	52,00%	47,00%				Enabling Employees to Get Involved (i.e., Volunteer Hours For Employees To Use)
Blad1

Cell Formulas
Range	Formula
H2:H11,J2:J11,I2:I12	H2	=FILTER(SORTBY($A$2:$A$47,C2:C47,-1),C2:C47>=LARGE(C2:C47,10))
Dynamic array formulas.

Awosome

Can we also have a data beside each top 10 statements


Thanks in Advance

Regards,
Sanjeev

 

[BSALV]

i suppose you only wanted the concerning column

Map1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1		Gen Z	Millennials	Gen X	Boomers			Gen Z				Millennials				Gen X				Boomers
2	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	76,00%	66,00%	68,00%	69,00%		1	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	76,00%		1	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	69,00%		1	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	70,00%		1	Long-term Incentives (e.g., Stock Awards)	79,00%
3	Mental Health Days Off	75,00%	65,00%	63,00%	58,00%		2	Mental Health Days Off	75,00%		2	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	66,00%		2	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	70,00%		2	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	74,00%
4	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	73,00%	65,00%	70,00%	68,00%		3	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	73,00%		3	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	66,00%		3	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	68,00%		3	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	69,00%
5	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	71,00%	61,00%	70,00%	74,00%		4	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	71,00%		4	Recognition Programs (i.e., Employees Can Send/Receive Points For Award Redemption)	66,00%		4	Four-day Work Week (i.e., 40 Hours Over 4 Days)	68,00%		4	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	68,00%
6	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	70,00%	66,00%	66,00%	76,00%		5	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	70,00%		5	Mental Health Days Off	65,00%		5	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	66,00%		5	Communicating Corporate Responsibility POV to Employees	65,00%
7	Summer Hours (e.g., Half-day(s) Off Per Week During The Summer)	68,00%	64,00%	62,00%	61,00%		6	Summer Hours (e.g., Half-day(s) Off Per Week During The Summer)	68,00%		6	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	65,00%		6	Long-term Incentives (e.g., Stock Awards)	66,00%		6	Working Remotely	61,00%
8	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	67,00%	69,00%	63,00%	67,00%		7	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	67,00%		7	On-site Gyms Or Gym Membership Discounts	62,00%		7	Mental Health Days Off	63,00%		7	E-learning & Self-guided Tools to Learn at My Own Pace	59,00%
9	Fun Perks (Fun Perks (e.g., GrubHub Points, Dogs at Work, Event Tickets)	67,00%	58,00%	48,00%	43,00%		8	Fun Perks (Fun Perks (e.g., GrubHub Points, Dogs at Work, Event Tickets)	67,00%		8	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	61,00%		8	Rotation Programs to Explore/Try Different Roles	60,00%		8	Communication About Policies, Diversity, And/or Inclusion	56,00%
10	Rotation Programs to Explore/Try Different Roles	64,00%	59,00%	60,00%	58,00%		9	Rotation Programs to Explore/Try Different Roles	64,00%		9	Hybrid Work Model (remote + In-office)	61,00%		9	Working Remotely	60,00%		9	Mentorship Programs	53,00%
11	Stress Or Mindfulness Programs	64,00%	56,00%	55,00%	46,00%		10	Stress Or Mindfulness Programs	64,00%		10	Tuition Reimbursement Programs	55,00%		10	Stress Or Mindfulness Programs	55,00%		10	Ensures Workforce Profile Adheres To Diversity Standards	46,00%
12	Allowing Personal Interest/passion Projects Into Work	64,00%	56,00%	52,00%	47,00%		11	Allowing Personal Interest/passion Projects Into Work	64,00%		11	-	-		11	Enabling Employees to Get Involved (i.e., Volunteer Hours For Employees To Use)	55,00%		11	-	-
13	Working Remotely	64,00%	55,00%	60,00%	61,00%		12	Working Remotely	64,00%		12	-	-		12	-	-		12	-	-
14	Programs Allowing Managers To Reward Direct Reports w/Spot Bonuses, Etc.	63,00%	66,00%	63,00%	62,00%		13	-	-		13	-	-		13	-	-		13	-	-
15	Long-term Incentives (e.g., Stock Awards)	63,00%	64,00%	66,00%	79,00%		14	-	-		14	-	-		14	-	-		14	-	-
16	Career/Personal Training (Coaching, Leadership Dev.)	63,00%	63,00%	55,00%	64,00%		15	-	-		15	-	-		15	-	-		15	-	-
Blad2

Cell Formulas
Range	Formula
H2:I16	H2	=IFERROR(INDEX(FILTER(SORTBY($A$2:$B47,$B2:$B47,-1),$B2:$B47>=LARGE($B2:$B47,10)),SEQUENCE(15),TRANSPOSE({1;2})),"-")
L2:M16	L2	=IFERROR(INDEX(FILTER(SORTBY($A$2:$C47,$C2:$C47,-1),$C2:$C47>=LARGE($C2:$C47,10)),SEQUENCE(15),TRANSPOSE({1;3})),"-")
P2:Q16	P2	=IFERROR(INDEX(FILTER(SORTBY($A$2:$D47,$D2:$D47,-1),$D2:$D47>=LARGE($D2:$D47,10)),SEQUENCE(15),TRANSPOSE({1;4})),"-")
T2:U16	T2	=IFERROR(INDEX(FILTER(SORTBY($A$2:$E47,$E2:$E47,-1),$E2:$E47>=LARGE($E2:$E47,10)),SEQUENCE(15),TRANSPOSE({1;5})),"-")
G2:G16,S2:S16,O2:O16,K2:K16	G2	=ROW()-1
Dynamic array formulas.

 

[sksanjeev786]

i suppose you only wanted the concerning column

Map1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1		Gen Z	Millennials	Gen X	Boomers			Gen Z				Millennials				Gen X				Boomers
2	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	76,00%	66,00%	68,00%	69,00%		1	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	76,00%		1	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	69,00%		1	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	70,00%		1	Long-term Incentives (e.g., Stock Awards)	79,00%
3	Mental Health Days Off	75,00%	65,00%	63,00%	58,00%		2	Mental Health Days Off	75,00%		2	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	66,00%		2	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	70,00%		2	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	74,00%
4	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	73,00%	65,00%	70,00%	68,00%		3	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	73,00%		3	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	66,00%		3	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	68,00%		3	Flexible Work Hours (e.g., Working 6-2 Instead Of 9-5)	69,00%
5	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	71,00%	61,00%	70,00%	74,00%		4	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	71,00%		4	Recognition Programs (i.e., Employees Can Send/Receive Points For Award Redemption)	66,00%		4	Four-day Work Week (i.e., 40 Hours Over 4 Days)	68,00%		4	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	68,00%
6	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	70,00%	66,00%	66,00%	76,00%		5	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	70,00%		5	Mental Health Days Off	65,00%		5	Committed To Changing Company Policies/Practices (listening To Employees, Unions)	66,00%		5	Communicating Corporate Responsibility POV to Employees	65,00%
7	Summer Hours (e.g., Half-day(s) Off Per Week During The Summer)	68,00%	64,00%	62,00%	61,00%		6	Summer Hours (e.g., Half-day(s) Off Per Week During The Summer)	68,00%		6	Flexible Work Week (e.g., Working Any 5 Days Of The Week That Work For You)	65,00%		6	Long-term Incentives (e.g., Stock Awards)	66,00%		6	Working Remotely	61,00%
8	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	67,00%	69,00%	63,00%	67,00%		7	Employee Assistance Programs (i.e., to Help Cope with Crises and/or Stress)	67,00%		7	On-site Gyms Or Gym Membership Discounts	62,00%		7	Mental Health Days Off	63,00%		7	E-learning & Self-guided Tools to Learn at My Own Pace	59,00%
9	Fun Perks (Fun Perks (e.g., GrubHub Points, Dogs at Work, Event Tickets)	67,00%	58,00%	48,00%	43,00%		8	Fun Perks (Fun Perks (e.g., GrubHub Points, Dogs at Work, Event Tickets)	67,00%		8	Prioritizes Productivity (i.e., Can Leave if Done in <8 hours)	61,00%		8	Rotation Programs to Explore/Try Different Roles	60,00%		8	Communication About Policies, Diversity, And/or Inclusion	56,00%
10	Rotation Programs to Explore/Try Different Roles	64,00%	59,00%	60,00%	58,00%		9	Rotation Programs to Explore/Try Different Roles	64,00%		9	Hybrid Work Model (remote + In-office)	61,00%		9	Working Remotely	60,00%		9	Mentorship Programs	53,00%
11	Stress Or Mindfulness Programs	64,00%	56,00%	55,00%	46,00%		10	Stress Or Mindfulness Programs	64,00%		10	Tuition Reimbursement Programs	55,00%		10	Stress Or Mindfulness Programs	55,00%		10	Ensures Workforce Profile Adheres To Diversity Standards	46,00%
12	Allowing Personal Interest/passion Projects Into Work	64,00%	56,00%	52,00%	47,00%		11	Allowing Personal Interest/passion Projects Into Work	64,00%		11	-	-		11	Enabling Employees to Get Involved (i.e., Volunteer Hours For Employees To Use)	55,00%		11	-	-
13	Working Remotely	64,00%	55,00%	60,00%	61,00%		12	Working Remotely	64,00%		12	-	-		12	-	-		12	-	-
14	Programs Allowing Managers To Reward Direct Reports w/Spot Bonuses, Etc.	63,00%	66,00%	63,00%	62,00%		13	-	-		13	-	-		13	-	-		13	-	-
15	Long-term Incentives (e.g., Stock Awards)	63,00%	64,00%	66,00%	79,00%		14	-	-		14	-	-		14	-	-		14	-	-
16	Career/Personal Training (Coaching, Leadership Dev.)	63,00%	63,00%	55,00%	64,00%		15	-	-		15	-	-		15	-	-		15	-	-
Blad2

Cell Formulas
Range	Formula
H2:I16	H2	=IFERROR(INDEX(FILTER(SORTBY($A$2:$B47,$B2:$B47,-1),$B2:$B47>=LARGE($B2:$B47,10)),SEQUENCE(15),TRANSPOSE({1;2})),"-")
L2:M16	L2	=IFERROR(INDEX(FILTER(SORTBY($A$2:$C47,$C2:$C47,-1),$C2:$C47>=LARGE($C2:$C47,10)),SEQUENCE(15),TRANSPOSE({1;3})),"-")
P2:Q16	P2	=IFERROR(INDEX(FILTER(SORTBY($A$2:$D47,$D2:$D47,-1),$D2:$D47>=LARGE($D2:$D47,10)),SEQUENCE(15),TRANSPOSE({1;4})),"-")
T2:U16	T2	=IFERROR(INDEX(FILTER(SORTBY($A$2:$E47,$E2:$E47,-1),$E2:$E47>=LARGE($E2:$E47,10)),SEQUENCE(15),TRANSPOSE({1;5})),"-")
G2:G16,S2:S16,O2:O16,K2:K16	G2	=ROW()-1
Dynamic array formulas.

Thank you so much.....!

Really it saves me a lot of time and avoids manual tasks!!!

you guys are Super genius!!!!!!