Rank from 1-37

[Winehouse]

Hi

I have 37 numbers in J5-J41, which I would like to rank from 1-37. Highest number at position 1.

I’m having trouble working this out.

Thank you for your help.

Regards

 

[Logit]

.
Could you just sort those cells from Highest to Lowest ?

 

[Winehouse]

Apologies. I wanted to rank them so the rank score is in another column.

 

[brokerCA]

=RANK(j5,$j$5:$j$41)

 

[DanteAmor]

Excel Workbook
	A	J	K	L	M
1
2
3
4		Num	Score		Rank
5		7	460		1
6		2	410		2
7		12	410		3
8		10	380		4
9		6	370		5
10		8	350		6
11		9	347		7
12		4	315		8
13		1	310		9
14		11	305		10
15		5	280		11
16		3	249		12
Hoja3

Then you order by column M from highest to lowest

 

[Winehouse]

That’s great.

Thank you for all your help.

Apologies for the late reply. While I was inputting this, the sheet became corrupted & several columns displayed a lot of garbage. I noticed some formulae had jumped into different cells. All I did was press undo as I had inputted something wrong & the errors appeared.

I tried redo, but to no avail.

I’m relatively new to spreadsheets, is this a regular occurrence? I know it’s caused me a whole lot of work to get a lot of info back....