Use MAXIMUM to Rank Months 1-12

[Justinian]

I am tracking net income for each of the 12 months. I need to rank each month from most profitable (1) through least (12). I can use MAXIMUM to get the largest number but how can I apply a formula to all 12 months so that Excel calculates which number is higher and applies a 1-12 ranking to each month?

 

[Joe4]

Perhaps you are looking for the RANK function?

RANK Function

The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time).

exceljet.net

 

[Justinian]

I am not sure RANK will work or I just am not familiar enough with it.

 

[Joe4]

Post a sample of your data and your expected output, so we can clearly see what you are after.

 

[Justinian]

Here it is:

Month	NOI	Rank
Jan	$ 5,253.00	8
Feb	$ 88,687.00	1
Mar	$(12,721.00)	11
Apr	$(13,398.00)	12
May	$ 53,152.00	4
Jun	$ 11,504.00	7
Jul	$ 80,916.00	2
Aug	$ 4,358.00	9
Sep	$ 3,229.00	10
Oct	$ 30,092.00	5
Nov	$ 56,235.00	3
Dec	$ 17,339.00	6

 

[lrobbo314]

Book2
	A	B	C	D
1	Month	NOI	Desired	Formula
2	Jan	5253	8	8
3	Feb	88687	1	1
4	Mar	-12721	11	11
5	Apr	-13398	12	12
6	May	53152	4	4
7	Jun	11504	7	7
8	Jul	80916	2	2
9	Aug	4358	9	9
10	Sep	3229	10	10
11	Oct	30092	5	5
12	Nov	56235	3	3
13	Dec	17339	6	6
Sheet2

Cell Formulas
Range	Formula
D2:D13	D2	=RANK(B2,$B$2:$B$13)

 

[Justinian]

That works except I get the same rank for different amounts: $304,593 gives me same rank number as $304,472.

 

[Joe4]

That works except I get the same rank for different amounts: $304,593 gives me same rank number as $304,472.

Neither of those numbers are in the example you posted.
Please post the example where it doesn't work for you, along with the formula you are using.

 

[Justinian]

Sorry, I am an idiot - I did not lock my cell references.

Thank you!