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

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