RANK.EQ excluding Blanks

[iggydarsa]

I have a table (tbl) with columns of Site and Sale
I want to Rank the Sales where Site is not blank.

On Column C (Rank) I using

=RANK.EQ([@Sale], [Sale], 1)

but not sure how to exclude the Site where it is blank so that the resultset would be like Column D (Expected)

Site	Sale	Rank	Expected
A	10​	1​	1​
C	15​	4​	3​
	13​	3​
B	12​	2​	2​
D	17​	5​	4​

Thanks!

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	Site	Sale	Rank
2	A	10	1
3	C	15	3
4		13
5	B	12	2
6	D	17	4
Data

Cell Formulas
Range	Formula
C2:C6	C2	=IF(A2="","",COUNTIFS($A$2:$A$6,"<>",$B$2:$B$6,"<"&B2)+1)

 

[iggydarsa]

Beautiful, thank you!

And what if I wanted to do it in reverse order, meaning
4
2
-
3
1

 

[Fluff]

Just change the "<" to ">"