P
paranous
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Hello,
I am unsure how to do the following in Excel. Here's what I have and what I'd like to do:
I have a list of universities and associated data (e.g. number of faculty, research award funding, etc.). It's easy for me to create the columns and sort by the criterion I am interested in, in order to get a ranking by that criterion. But what I'd like also to do is to create rankings based on those criterions. So, for example, I'd like to have column that simply lists the rank order of the universities when I sort by criterion A. I have figured out how to do this. But I want to be able to do this with EACH criterion (e.g. A, B, C,) without disrupting the rank order for the previous criterion. Why I want to do this is because i then want a final field that sums the rank number for each criterion to get a meta-ranking of the universities (e.g. a Bordq Count). In other words, I want to be able to sort the university list by different criterion (1 at a time) and be able to retain the rank numbers for each sorting, without them changing when I re-sort based on the next criterion. Any ideas? I know it's a bit complicated - Here is a simple example using just 3 criterion:
Institution Faculty # Grants Received ($) Endowment ($)
Alpha 234 10,567 600
Beta 569 9,876 857
Chi 71 7,952 1175
Delta 1198 2408 1897
It's straightforward to sort by criterion. I can even add a Ranking column that will provide the correct ranking for each institution, depending on the column sorted. However, every time one re-sorts based on another criterion, this ranking changes as well, meaning that I can take the rank order for each criterion and sum them up. I could simply cut-and-paste the results for every sort, but I want this to update automatically.
Any thoughts? Thanks!
Jay
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Hello,
I am unsure how to do the following in Excel. Here's what I have and what I'd like to do:
I have a list of universities and associated data (e.g. number of faculty, research award funding, etc.). It's easy for me to create the columns and sort by the criterion I am interested in, in order to get a ranking by that criterion. But what I'd like also to do is to create rankings based on those criterions. So, for example, I'd like to have column that simply lists the rank order of the universities when I sort by criterion A. I have figured out how to do this. But I want to be able to do this with EACH criterion (e.g. A, B, C,) without disrupting the rank order for the previous criterion. Why I want to do this is because i then want a final field that sums the rank number for each criterion to get a meta-ranking of the universities (e.g. a Bordq Count). In other words, I want to be able to sort the university list by different criterion (1 at a time) and be able to retain the rank numbers for each sorting, without them changing when I re-sort based on the next criterion. Any ideas? I know it's a bit complicated - Here is a simple example using just 3 criterion:
Institution Faculty # Grants Received ($) Endowment ($)
Alpha 234 10,567 600
Beta 569 9,876 857
Chi 71 7,952 1175
Delta 1198 2408 1897
It's straightforward to sort by criterion. I can even add a Ranking column that will provide the correct ranking for each institution, depending on the column sorted. However, every time one re-sorts based on another criterion, this ranking changes as well, meaning that I can take the rank order for each criterion and sum them up. I could simply cut-and-paste the results for every sort, but I want this to update automatically.
Any thoughts? Thanks!
Jay