Ranking by multiple criteria

[monkeyspank]

I would like to rank the below by month based on kWh_SQFT..., is this possible?

Location Number	Bill Month	kWh_SQFT
100	9/1/2017	23
300	9/1/2017	17
400	9/1/2017	14
900	9/1/2017	11
1200	9/1/2017	8
2100	9/1/2017	10
2600	9/1/2017	7
2800	9/1/2017	10
3600	9/1/2017	12
4300	9/1/2017	14
4900	9/1/2017	7
5000	9/1/2017	6
5100	9/1/2017	11
5300	9/1/2017	17
6000	9/1/2017	4
6200	9/1/2017	367
7500	9/1/2017	5
7600	9/1/2017	7

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[CyrusTheVirus]

D2:

=rank.eq(c2,$c$2:$c$19)