Calculating Rank
Ok, say I have a list of 50 states, all ranked according to different metrics. Where each state’s rank changes from list to list.
What I need to do is this:
First, create a matrix with a list of all 50 states. Then, based on the name of the state, will look in each list, and add up the appropriate rank. For example:
Nevada is ranked 1,5,7,15 on four lists. The final matrix will look in each list and add up the above numbers. I have attached an example model (very simple). Is there a formula that can do this? Tks!
Mike,
Thanks for your reply. Unfortunately, the original tables were built from importing data for each Rank1, Rank2, etc. through the DataLink. So it was not possible for me to link the state category, unless there is a way to do it after the fact. I do know that the list of states is the same, even if in different order.
Barring the option of a linked state category, is there a way to add up the rankings?