Conditional Rank

[CentaurSaratoga]

Hi, Long Ago Mr.Excel Fielded a call to this board regarding "cond/rank" where a specific group (Gov't) was excluded:Rank the remaining..Works GREAT except it returns in ascending and I need Z-A Q? How to amend?

=IF(A2<>"x",SUMPRODUCT(($A$2:$A11<>"x")+0,(C2>$C$2:$C$11)+0)+1,"")

Column runs to A2-A12,C2-C12

P.S. This GREAT formula is the work of Tom Urtis

 

[Sal Paradise]

Try this:
=COUNTIF($A$2:$A$11,"<>x")-IF(A2<>"x",SUMPRODUCT(($A$2:$A11<>"x")+0,(C2>$C$2:$C$11)+0)+1,"")+1

Just takes the total of the non-x items, and subtracts the rank. That should give it in reverse order.

 

[CentaurSaratoga]

Thank You ! My son is off @ College and I am not familiar w/technique but I will persevere and with great people like yourselves will become an adept
amateur...