Solved

ranking a set of values in Excel

Posted on 2014-12-01
6
96 Views
Last Modified: 2014-12-01
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
Comment
Question by:LeTay
  • 3
  • 3
6 Comments
 

Author Comment

by:LeTay
Comment Utility
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

by:Phillip Burton
Comment Utility
=IFERROR(RANK(A1,$A$1:$A$5),"")
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
Comment Utility
If you are using Excel 2003 or earlier:

=IF(A1="","",RANK(A1,$A$1:$A$5))
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:LeTay
Comment Utility
Thanks...
I use a french version of Excel
Do you know what the equivalent is for "rank()"
0
 
LVL 24

Expert Comment

by:Phillip Burton
Comment Utility
RANG
0
 

Author Comment

by:LeTay
Comment Utility
Found it : rang !
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now