Rank Cells in Descending Order

[bored622]

Hello everyone,
I'm trying to create a formula that provides the rank of each cell from the lowest value to the highest without any duplicate ranks and ignores zeros.

Example:

Values	Rank
5	6
5	5
4	4
2	3
1	2
0
1	1
0

I appreciate any help.

 

[Phuoc]

Try this:

Book1
	A	B
1	Values	Rank
2	5	6
3	5	5
4	4	4
5	2	3
6	1	2
7	0
8	1	1
9	0
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=IF(A2=0,"",COUNTIFS($A$2:$A$9,"<"&A2,$A$2:$A$9,">0")+COUNTIFS(A2:$A$9,A2))

 

[bored622]

Try this:

Book1
	A	B
1	Values	Rank
2	5	6
3	5	5
4	4	4
5	2	3
6	1	2
7	0
8	1	1
9	0
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=IF(A2=0,"",COUNTIFS($A$2:$A$9,"<"&A2,$A$2:$A$9,">0")+COUNTIFS(A2:$A$9,A2))

thank you! that worked perfectly.