1. E

    RANKX with COUNT/SUM function

    Hi all, Stuck with the following : Name Due Status Active Overdue Person 1 On Time 0 Person 1 Overdue 1 Person 1 Overdue 1 Person 2 Overdue 1 Person 2 Overdue 1 Person 2 Overdue 1 Person 3 Overdue 1 Person 3 Overdue 0 Person 3 On Time 0 The above is the table...
  2. N

    Top15 words on worksheet 1

    Hi all, Recently I found this post on MrExcel Using Thesaurus with VBA Great tool, which I use to collect first associations with images. Since a synonym would also have done the job I decided to add up to 10 of them using the code mentioned above. Currently I use it on worksheet 1 (only the...
  3. 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.
  4. D

    Select registers without best results by category

  5. 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)...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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
  15. 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...
  16. 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...
  17. 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...
  18. 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
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back