Rank from 1-37

Winehouse

New Member
Joined
Jul 29, 2018
Messages
24
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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,598
.
Could you just sort those cells from Highest to Lowest ?
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
Excel Workbook
AJKLM
1
2
3
4NumScoreRank
574601
624102
7124103
8103804
963705
1083506
1193477
1243158
1313109
141130510
15528011
16324912
Hoja3


Then you order by column M from highest to lowest
 

Winehouse

New Member
Joined
Jul 29, 2018
Messages
24
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....
 

Watch MrExcel Video

Forum statistics

Threads
1,109,320
Messages
5,527,996
Members
409,798
Latest member
Snake68

This Week's Hot Topics

Top