Solved

# ranking a set of values in Excel

Posted on 2014-12-01
102 Views
I have a spreadsheet where cells, says A1 B1 C1 .....XX1 contains numerical values which are the result of some calculation
I want to have cells A2 B2 C2 ... XX2 containing the ranking (descending values) of corresponding values A1 B1 C1 ... XX1
For example with 5 cells A1 B1 C1 D1 E1 containing  12  23  98  33  10, cells A2 B2 C2 D2 D2 should contain 4  3  1  2  5
Is there a formula to calculate that ?
Thanks
0
Question by:LeTay
• 3
• 3

Author Comment

ID: 40473385
I forgot to write that some of these A1 B1 ... cells are empty and so should not participate to the ranking at all
0

LVL 24

Expert Comment

ID: 40473397
=IFERROR(RANK(A1,\$A\$1:\$A\$5),"")
0

LVL 24

Accepted Solution

Phillip Burton earned 500 total points
ID: 40473398
If you are using Excel 2003 or earlier:

=IF(A1="","",RANK(A1,\$A\$1:\$A\$5))
0

Author Comment

ID: 40473402
Thanks...
I use a french version of Excel
Do you know what the equivalent is for "rank()"
0

LVL 24

Expert Comment

ID: 40473407
RANG
0

Author Comment

ID: 40473410
Found it : rang !
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn the basics about Excel 2013’s new Flash Fill feature.
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.