rankif

I want to Rank Top 10 Products along with figure from another sheet as below. The other sheet contains similar Products name in multiple category with the total from each category. I tried INDEX & LARGE formula, but it did not work well because Total figure would become bigger. Would appreciate...

Is there a formula to find the highest score(s) for Bob in a list with all of his games, and all of his teammates games? Something like "MaxIf" would be perfect, but I don't think it exists. It seems logical, but I'm stumped. If that is possible, can it be taken a step farther to have a...

Hello, I am trying to rank values from largest to smallest between two sets of dates but running into some issues. The dates are in column B and I am trying to rank the numbers in column H and the ranking is in Column J. This is the formula that I am currently using...

Hi, I've read a lot of the forums on who to use rank based on multiple criteria, but I need to rank criteria based on multiple criteria. I tried using something like this: =COUNTIF($B26:$T26,">"&N26)+1+SUMPRODUCT(--($B26:$T26=N26),--($B27:$T27>N27)) but it doesnt work for what I'm looking...

I'm using SUMPRODUCT in place of the missing 'RANKIF' option in Excel2010, but there are gaps in the results. Ranking 1, 2, 3 might be populated correctly but there will be no result for ranking 4 and 5 for example. Why is this happening? And can I make a change to avoid this? Example of the...

Hi, I have a sum product forumla I am using as there is no RANKIF function in excel. The current formula I have is <bdo dir="ltr"> =1+sumproduct(($B$2:$B$119=B2)*($AQ$2:$AQ$119>AQ2)) This is where column B is a players position and column AQ is the amount of goals they have scored. The rank...

Hi, I've seen a thread with a similar question but the solution didn't work in my situation. I have a table that looks similar to this: Name Role Month Avg Rank Joe A 1/1/2016 97.0% Tim A 1/1/2016 94.1% Ann B 1/1/2016 96.5% Bob B 1/1/2016 94.0% Sue C 1/1/2016 85.0% Joe A 2/1/2016 100.0%...

Hello All, I've been using the RankIf functionality (based on SUMPRODUCT)that members have posted on here for a while now and it's great. However, I've run into a problem with a large simulation/optimization problem with this method. Every time it tries a new set of inputs it has to recalculate...

Hi Everyone, I have a large set of data in my excel spreadsheet with 9800 rows. I want use RANKIF function by comparing two columns. when I am trying to solve the problem using the below function =SUMPRODUCT(--(H2=$H$2:$H$9692),--(AZ2<$AZ$2:$AZ$9692))+1 it shows me a value error. I think due...

Hi - I am trying to rank a set of data based on a separate criteria (brand) from the ranking list (assortment size). I need the resulting data to be able to have duplicates, but not skip any numbers as I am going to use the rank results in a vlookup column reference formula. Each of the below...

Hoping for the excel gods to answer a question. I have data in a row like the example posted below. I want to rank the values (including positive/negative numbers), but need to ignore the zero's since a zero indicates no data was present. I can rank including the zeros, but that throws off the...

Hello people who are smarter than I :) I need a formula to rank a value 1-100, but then penalize any value that is above 100. Is is a "percent to budget" ranking, so going over budget can not help you rank the highest in the company. I would need the ranking to look something like this... The...

Hi all, I'm new to the MrExcel forum and this is my first post. :) I have a "RANKIF" formula using SUMPRODUCT: =SUMPRODUCT(--($B4=$B$4:$B$100),--($F4<$F$4:$F$100))+1 which works fine. At the moment "F" is the last column, but the table will expand to the right so the last column reference...