Rank test scores, in descening order but, omitt values below a specified cut-off point

similoluwa

New Member
Joined
Apr 9, 2010
Messages
2
Hello,

I need to run a macro to rank test scores in descending order but I would like to omitt values below a specific value, so that those who do not make the cut-off are listed as zero and those who do are included on the rank
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

jbeaucaire

Well-known Member
Joined
May 8, 2002
Messages
6,012
Something like:

=IF(A1>50, RANK(A1, $A$1:$A$50), "")

Excel Workbook
AB
1858
26512
37011
45514
545
6809
7907
850
91054
1040
111103
121005
131152
147510
151201
166013
17956
Sheet4
 

Watch MrExcel Video

Forum statistics

Threads
1,118,099
Messages
5,570,206
Members
412,308
Latest member
jt145
Top