# Get instant live Excel expert help to learn how to rank in Excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

i have a list of names and the ratings next to them and im wondering if i can count how many consecutive times a person is ranked a certain rank. can you help me with how to use rank in excel
Solved by X. U. in 11 mins
You entered your formula in a cell: =G66+22+(H70/5)*7 Rank the steps Excel 2010 performs to evaluate the formula, base on the default precedence rules it uses.
Solved by I. J. in 30 mins
I'm trying to write a formula that would find the percentage of Invoices that have stayed in the same Row rank for 2 months. The sheet I'm working on is labeled Top X and the formula should be written starting in Q200. The Row rank is found in column J, the Account ID is column B, and the Date range is in C.
Solved by G. J. in 22 mins
I'm trying to write a formula that would find the percentage of Customer Invoices that have stayed in the same Row rank (Column J) for 2 consistent months. The rankings are segmented based on the criteria in Column P. The sheet I'm working on is labeled Top X and the formula should be inputted in Q200:AZ212. The Row rank is found in column J, the Account ID is column B, and the Date range is in C (note the date range is Text, but the corresponding Dates needed for segmenting the data are located in Q2:AZ2. Please let me know if you have any questions!
Solved by F. F. in 18 mins
Help with rank formula in excel with example! i am ranking information and need to rank the rankings. For example there are nine rankings- for each first place 3 points are awarded, 2 for second and 1 for first - how can i create a formula that recognizes this and calculates the position the person is in based on the points awarded for each ranking?
Solved by I. A. in 19 mins
how to use rank function in excel pivot tables? I have a sheet that is not showing rank results properly
Solved by E. B. in 30 mins
I need help with rank order for the three columns of numbers prioritising the columns in order A, B, C,
Solved by S. Y. in 27 mins
I have a spread sheet with the rank function excel not working properly
Solved by S. H. in 15 mins
I need to write a conditional formula that provides a yes or no answer with the following conditions. You must have a 2.0 GPA If you have a 2.0 you must have a 20 on the ACT OR rank in the top 1/3 or your class. If these conditions are met then yes=QA; if the conditions are not met then No
Solved by E. L. in 20 mins
I'm looking for a formula that will rank a column. The data in the column is percentages. I want the data to be ranked with 100% being #1 and the lower percentages ranked higher; but, I need this formula to rank percentages < 100% at a lower ranking. Columns 'D' & 'N' contains data that is greater than 100% and it is causing that higher data to have a lower ranking.
Solved by D. C. in 29 mins