rank 2 columns

So here's the set up. I need to rank a time in Column S in ascending order (fastest to slowest), but with consideration of the number of penalties in Column T. It seems like it should be easy, but it's a bit vexing. The ranking is no problem as long as everyone has a slightly different time...

Hi, I need some help with a spreadsheet that I cannot change the source data (raw data), which is extracted from a report. Basically, I need to identify the products with highest satisfaction rating among a plethora of products, in a single column with data that goes from smartphones, tablets...

Hi All, I am looking to get a rank column as shown below using some rank functions. We have to group all same locations and rank within the group. Then, the lowest sales should get the first rank. If the sales are same, the rank should be given based on the second Column Amount. For example...

Hello, I am currently struggling on how I can rank a subsection within a section based on a #. To make this easier, I will explain it like this. I have 4 separate "portfolios" in column "I". I have Different sub customers within those portfolios in column "K". I would like to rank these sub...

I have a table with two columns. The table starts in column B. In column B is a dynamic list, let's say company names. If my Excel tool only assessed 5 of 10 companies, then 5 companies will be listed in column B in rows 1:5. In rows 6:10 will be blanks because the assessment didn't include...

I'm facing a issue with ranking in Excel particularly in regards to tie breaking. I tried several options but i guess they don't fit my issue. Its quite simple really, I'll explain: The demo data: <tbody> row1 a b c d e f g h i j row2 1 2 3 4 5 6 7 8 9 10 row3 row4 87 83 74...

Hi all going round in a few circles :confused: I have a table listing product(A), month(B) and sales value(C) I want to rank sales value within the months (so each month has a number 1) product month sales value rank a jan 1000 1 a...

I'm trying to rank names based on score. My problem is, I have 6 people with 100% score, & it's returning 6 rows of the same person's name & none of the others who scored 100%. How can I make it get the next person on the list from range O7:P18 ? I'm assuming some sort of IF or OFFSET, but...

I am having trouble ranking my data in Excel based on 2 columns. The 2 columns are CYCLE and DURATION. The ranking should work like this: It should rank CYCLE first then DURATION second. The formula should work even if the data is not sorted or with blanks. For instance, here is my sample...