1. R

    Single Ranking with Two Data Sets in One Column

    I'm trying to rank scored participants from highest score to lowest with one added criteria. Those who fouled, designated by an asterisk before the score, are still given a score but ranked lower than all the ones who did not foul.
  2. D

    Select registers without best results by category

  3. V

    Exclude some records from a SUMPRODUCT ranking formula

    Hi, I have a table of SalesReps with a two ranking formulas. The resulting rankings are used on dashboards on other worksheets. The formulas rank the performance of SalesReps within each RepGroup in ASC and DESC order (so that we can report on the top performing and bottom performing reps)...
  4. B

    Ranking with Tiebreakers

    Need some help ranking, this is just a small sample. I found a formula on here to rank the teams based on columns D & F, but can't figure out how to use L as a tiebreaker instead of order in the spreadsheet. Obviously this is just a small sample of the sheet there are more columns so the...
  5. M

    RANK(SUMPRODUCT Unique Ranking With Tie Breaker Problem

    Hi there... I am having a bit of trouble with the formula below which is intended to provide a unique (no duplicates) ranking of Productivity scores (highest to lowest) using another metric as tie breaker as needed (lowest Score is best). The formula is used in cells AM7:AM31 and the tie...
  6. M

    IF AND Formula with a Date and Percent

    I am trying to create an IF AND formula that looks at a cell with a Date to see if it is 30 days from Today and then looks at another cell with a ranking percent and return true/false text. Below is my formula which is not working. =IF(AND(D2=TODAY()+30,G2<0.8),"OK","REVIEW") What is a better...
  7. J

    Formula(?) to create a ranking + a count of the values in a column?

    Hi there, and thank you in advance! I really, really appreciate this forum! :) I have data which was not set up in an easy manner to pull information from, so I would love to see if this is possible to do: I'd like to use a formula beneath each column, which would display values in a column...
  8. W

    ImportXML function to extract data

    Dear All, Kindly need your help. I have a task to extract some data for multiple websites. I found out that it's possible to do with ImportXML in Google Docs. That would be superb but I'm a bit lost how to write the formula. An example, I need to extract the ranking number from the following...
  9. R

    Rank using 2 tie breaker columns

    Hello, I am needing to rank a table that has columns for Names, Point Totals, Avg Race Position, and Avg Qualify Position. The ranking should be by largest point totals, however if there is a tie, the first tie breaker would be by lowest avg race position, and if still a tie, by lowest qualify...
  10. J

    RANK by two columns to exclude rows with a specific cell value in a third column

    <tbody> A B C D 1 BRANCH CLIENT FILECNT RANK 2 12 ABRE01 50 1 3 12 AEVA01 45 2 4 12 NIEX01 46 5 12 NIEX02 47 6 12 CAI00 29 3 7 32 ABRE02 15 3 8 32 AEVA01 45 1 9 32 NIEX05 9 10 32 NIEX07 47 11 32 CAVI00 40 2...
  11. JenniferMurphy

    Showing the direction a value is moving

    I sometimes create sheets to track the standings of sports teams. Some of these sheets contains rankings. Over time, the rankings change. In the past, I have calculated the change in rank by subtracting the old ranking from the new one (=NewRank-OldRank). This works, but can be a little...
  12. A

    Sorting in Excel using Ranking and sumproduct

    I want to create the ranking based on 3 columns without sorting method. How can I make this in excel? I saw people using rank and sumproduct, but can you teach me? https://imgur.com/kG5eVlF
  13. L

    index match, multiple columns/array with date, strings and blank cells

    Hi, I have a problem regarding a structure for project management and specifically deadlines. On the rows I have different customers/projects which each have columns with different activities, e.g.: <tbody> Project/Customer Deadline activity 1 Deadline activity 2 Deadline activity 3...
  14. M

    Ranking by multiple criteria

    I would like to rank the below by month based on kWh_SQFT..., is this possible? <colgroup><col><col><col></colgroup><tbody> Location Number Bill Month kWh_SQFT 100 9/1/2017 23 300 9/1/2017 17 400 9/1/2017 14 900 9/1/2017 11 1200 9/1/2017 8 2100 9/1/2017 10 2600 9/1/2017 7 2800...
  15. C


    How do I do a ranking in Access? May Query Produces <caption>qryWest HI Dairy</caption> <thead> Vendor MaxOfItem Expr1 Expr2 </thead> <tbody> 520215 447036 58 $1.08 520215 447036 1 $10.28 520215 447036 1 $10.64 </tbody> <tfoot></tfoot> I need to have a...
  16. F

    How to sort the Ranking in pivot from highest to lowest

    I inserted a ranking in my pivot table based on the final score. But when i am trying to sort it from smallest to highest, it does not work. How can i sort it. Thanks
  17. S

    Auto Ranking by Total Score

    Hello- I want to Auto Rank a list by a Total Score column. The current table was generated using formulas from another sheet that can allow additional rows. I also want to make sure any new or deleted records get reflected in this final table. Thank you <colgroup><col...
  18. S

    Ranking Data in Alphabetical Order

    I would appreciate some help with this task as I am really stuck trying to work this out. I will try my best to explain it. I have 2 worksheets in the excel file. The first worksheet is where all the data is sent from the 3rd party software. I have no control over how the data is displayed on...
  19. S

    Pivot table subtotals showing average, how to get that into a percentage?

    Hello all, I'm completely new to pivots in general, but it seems like my expectations are already leading me to look for something more advanced than my knowledge would allow. My source of data is a list of products and their weekly rankings. My pivot table shows product's ranking on weekly...
  20. H

    ranking adjustment with countif formula

    {=IF(ISERROR(AA2),DM2,COUNTIFS($DO:$DO,$DO2,AA:AA,"<"&AA2)+COUNTIFS($DO2:$DO2,$DO2,AA2:AA2,AA2))} Hello, im trying to work out what i can add to this array formula, which will stop the 'equal numbers' appearing with the same duplicate rank number. For example, it currently works like this...

Some videos you may like

This Week's Hot Topics