I've found a dynamic rank formula on the web that updates the rank as I filter, but I need to add another level, so it's ranking by country. I don't really understand how the formula works, so I'm unable to edit this myself.
This is the formula that I am using -...
I'm trying to create a top 10 ranking list and would like to add a condition that regardless of the rank/performance score, the highest performers in a key country will always be included in the final list.
The mini sheet below contains two tables. The left table is the main table and the...
In a worksheet, I would like to rank people's scores (in descending order) but only if their associated status is "Move forward". For the other statuses of "Proceed with Caution" and "Do not Proceed", they'd be ranked after and listed at the bottom.
The rank function using sumproduct supports multiple conditions and is really handy.
I found out how to modify the RANK function to support arrays (multiple columns) using something like the following function...
i would like to create the condition in the RANKing formula that all cells containing a 0 are not included in the ranking
the formula is:
i would like to include something like this
IF C22=0 do not include calculating the ranking and display nothing in the cell...
Right now i have the following in A1:B9
and my conditional rank with formula copied down from C2 to C9 is:
and I am getting this:
Code Name Rank By...