rankings

Hey again, guys. I have a new problem, that I can´t get to the solution after trying a lot of formulas, and being stuck to this for a day. So, I have an excel file where I compare several quotes to make a decision. I have spaces to compare nine quotes, but I don't always get nine, leaving some...

I have this information in which applicants for a conference are ranking their preferences for example (red, yellow, orange). What formula can I write so that I give the person their first choice, but then when that area gets filled up with more than 1/3 of the people at that conference it shows...

Hello, I have a large worksheet with 8693 rows and 69 columns and I would like to rank how many times a customers name is mentioned in a column. I'm familiar with filtering and pivot tables but my skill levels require I manually add up the customer names. I thought I could use a =RANK formula...

I sometimes create sheets to track the standings of sports teams. Some of these sheets contains rankings. Over time, the rankings change. In the past, I have calculated the change in rank by subtracting the old ranking from the new one (=NewRank-OldRank). This works, but can be a little...

I have an Excel 2010 workbook with multiple columns for users to enter their rankings (one column per user). I then want to calculate simple and wtd averages and do some analysis. What's the best way to have them enter their rankings? I was thinking about making the file shared but then how do...

This one has got me puzzled and I'm sure there is a simple solution. I have a long list of rankings for various statistical tests, i.e., A 1 B 2 C 3 A 2 B 3 C 1 and so on. I just want to determine how many 1st, 2nd and 3rd place rankings of A, then of B, etc. There is no real range to use a...

I am ranking our target schools by their school level. The rankings appear how they should in a grid view with all schools selected. However, when a single school is selected in the slicer, the ranking changes. For instance, Appalachian State University is ranked #1 in the national school...

Hye, I have coded the below as macros. It works successfully, just that consumes inconsiderable amount of time to process even just for 20 to 30 rows of data. Appreciate if anyone who is expert to correct or improve my coding below to allow much faster processing :- Sub Rank() Dim FPart1...

I am trying to do an excel spreadsheet and in my case we are doing a study of per capita income in different regions. 1 is of course best. 3141 is worst. However, excel wants to make the best ranking ( 1 ) flat and it makes it appear that it is not the best ranking. I also neeed to know how to...

Hello everybody! I am new to this and I need a little help on the forum. I have a file where I write down the results of a football league and automatically generates me the ranking of the teams. In this rankings I can not apply the penalties (for example I have to apply a penalty of 1 point to...

Hi, I'm trying to elegantly show all of the rankings for my sales regions in one chart. The only thing I could come up with was a line chart (I know, lame!). Any suggestions? <colgroup><col style="width:48pt" span="16" width="64"> </colgroup><tbody> Computers Industrial Vehicles...

Hey Everyone Me and my friend are often in charge of scoring the high jump at athletics competitions. At the mo, we are trying to make a spreadsheet that automatically works out the competitor rankings for us as it currently takes us a long time doing it by hand! Can anyone maybe have a read...