rank if

hi I am having some issues trying to get quite a lot of data ranked correctly. I've done some reading and possibly I need to use COUNTIF rather than RANK. Here is what I am trying to do. I have around 140,000 rows of data with the first two columns being date and time. I have numbers in...

Good day i am administering a competition in excel. the participants are split per region and each one has a sales figure and sales target. basically if you make your target, you get a prize. however the salesman with the highest value above target per region will get ad additional prize if...

I am trying to a Rank IF Statement to rank all Like entries based off their date to be produced. Below is a sample of what I am trying to rank however I just can't seem to get it to work. Thanks in advance for all the assistance. If status is "Clear to Pack" then rank "X1" Line using the...

I am creating a form to rank grant applications. I need to total all the points from various judges for each applicant, then rank them. This is an example of the data from sheet one: 09.27.2016-13.47.30 - GRogne1's library And this is sheet two: 09.27.2016-13.46.43 - GRogne1's library What...

hey guys, I think I have a low end solution but for bigger projects I need the following I want to put the rank in column A. In column B I have tenant names in text formats. In column C I have the size of their space. Many of the tenants have multiple spaces, I want to be able to rank based...

Hi All, Thanks again for your previous help on RANKIf without arrays. I am still working with the same basic model and had a new question. I currently have the first four columns of the table below. I am looking to create SalesmanInOrder which is simply a list of the salesman for a product in...

Hi all! I'm basically at a breaking point. I am trying to rank a file with sales by customer but the sales are broken out by a sub segment. I need to rank them at the total customer level. Below is a makeshift example of how my data looks (the rank column is the result I want): <tbody> Name...

Hello, I am trying to rank projects that have not been completed. Once the project has been completed, I do not want to show it as a top priority. Here is the formula I am using: =IF(T17="COMPLETE","",RANK(DB17,$DB$12:$DB$65,0)+COUNTIF($DB$12:DB17,DB17)-1) This does not show a rank for...

Hello everyone! I have a question about the RANK-function. I need to have a ranking, simple enough with the RANK function. BUT... There need to be 2 criteria in 2 other cells met before a ranking is assigned. For example: Cell AC4 is attendance, needs to be "Y". Cell AH4 is test result...

Hello, I'm trying to rank in ascending order the top 20 lowest margin generating items by week. I'm stumped on what sort of formula to use for this. I will have a data tab consisting of historical data from previous weeks. I would like to be able to call out the top 20 margin loss drivers by...