Excel Tip: Ranking numbers in Excel
From the Not Just Numbers blog:
Before I start, a couple of announcements.
First of all, please accept my apologies for the time between posts. A combination of workload and a family bereavement have slowed me down somewhat!
Secondly, if any of you will be in and around London tomorrow (Wednesday) night, the ICAEW are launching their Spreadsheet Competency Framework, with some top speakers from the world of Excel. This document (as suggested by its name) is intended to provide a framework to assess spreadsheet competency, and was developed by the Institute’s Excel Community Advisory Committee, of which I am a member. The event is free to attend, and further details can be found at:
I hope to see you there.
Right…on with the post.
There are many reasons, you might want to rank a list of numbers in Excel. One I do quite often, is produce a league table. By calculating the ranking of a number and then using lookups to populate a table in rank order, we can easily produce a league table, like the example below:
If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies “The 5 Excel features that you NEED to know” and “30 Chants for Better Charts”.
You might also be interested in
Chartered Accountant with extensive experience in management reporting, Microsoft Excel and business process improvement.
Also runs a spreadsheet development business at http://www.needaspreadsheet.com.
Provides consulting on the above...