ranking data

  1. P

    Ranking values in Excel

    I am working with a large data set. The values are included in two different columns. A lot of the values have very little value to the overall report impact. What I want to do is identify the top 10 items by percentages that have a number greater than 50 in my top 10 table separate from the...
  2. M

    DAX Top 10 and others

    Hi, I am new to DAX and struggling to find a formula to show me the top 10 customers then all others grouped together under "Others", as i want a clean looking pie chart. the field names are "SupplierName" and the values are "YTD Sales" not sure what other information is required. thanks...
  3. S

    Pull ranking & associated data - NON VBA - Possible?????

    Morning y'all! I am trying to figure out how I can pull some data over in a specific way to ensure that it matches my criteria. I have my source workbook which contains all data for Item, Location, Ranking (based upon location), & Data Points 1-10 (1 through 10). I also have my template sheet...
  4. S

    Ranking formula based on variable

    I have a table with country performance data & I would like to be able to see the best performing country on a certain date. The idea is that if I change the date in cell E10 (highlighted in red), the formula in E11 would display the country name of the highest value on that date. In the event...
  5. A

    Ranking and not showing ties

    I'm using this formula in Column A =IF(G3="","",IF(G3=G2,A2,ROW()-2)), which will show a tie for the same rank (i.e. Rank 1 [Bell and Brown] and Rank 4 for both Beckham and Elliott). What would be the formula to rank them 1-5? I would prefer not to show a tie. Thank you in advance! <tbody>...
  6. M

    Ranking with multiple of the same name in one column

    Hello, I am looking to fix my formula or understand a better formula to rank titles in one column where the title can appear multiple times with different number of units each time the title appears. Below is an example (Note I only included the rank in column C without the name of the title...
  7. N

    Ranking based on multiple columns having different weightage.

    There are multiple threads of Ranking based on multiple columns but still I am posting new. Please try to help me. <tbody> Circle Core Core Collector Collector Metro Metro AVL # of Links AVL # of Links AVL # of Links Kerala 97.85% 12 97.15% 20 99.42% 47 Punjab 99.89% 3 96.68% 1 99.82% 73...
  8. M

    Ranking Values with a nested Index+Match

    I have a sheet with economic indicators in column A, countries in B, and annual values in C-Z, and in AA I have the average annual value for that indicator. Indicators repeat for each country, and countries repeat for each indicator, so it looks like: Exports....US Exports....China...
  9. C

    Ranking with Multiple Columns

    I have a project that I am unable to figure out the best way how to accomplish. I have five players on our basketball that are having a contest. Each player took 25 shots. I need to rank each player's shots individually. For instance, Andrew made 24 and 23 (4th and 1st attempts respectively)...
  10. B

    RANK Solution needed please :)

    Hello All, Im sure you will be able able to help with the following question: I am trying to RANK a list of data but where the number maybe the same how can i get the formula to not have duplicates... So far example below i want James to be ranked 4th and Sally 5th even though they both had...
  11. B

    Ranking while ignoring zeros

    Hoping for the excel gods to answer a question. I have data in a row like the example posted below. I want to rank the values (including positive/negative numbers), but need to ignore the zero's since a zero indicates no data was present. I can rank including the zeros, but that throws off the...
  12. T

    Sorting summary data on one sheet to another sheet by rank

    I have created a Workbook that has a worksheet for each day of the month. Then each day there is a log of events setup with Providers listed down col A and possible events listed in the top Row. On the last worksheet I have the monthly totals which I have formulas showing the monthly total...
  13. S

    Need to return text from a cell based on 1st, 2nd, 3rd and 4th place ranking

    Thank you in advance for helping with this, I have been searching for 3 days now and cannot seem to find the magic formula. A1:A3, A4:6, A7:A9, A10:A12, A13:A15 & A16:A18 are merged in the actual spreadsheet. Column F is the results I am wanting returned. I need F1, F4, F7, F10 & F13 to...
  14. E

    Rank select cells only from a column

    Hi all! In the below example i need to only rank the topline (bold records) and ignore all the other values from the value column when ranking. The excel rank formula ranks "office" as 3 because "detached" (which is a row to be ignored when ranking) has a higher value. It should however be...
  15. D

    Ranking and creating a graph from it.

    Hello everyone! I apologize- I found another similar topic. I am trying to delete this thread but I'm not sure how to. -The newbie.
  16. S

    Access hangs on Ranking

    I am trying to rank 48000 rcds and on running query Access just hangs. Any suggestions to overcome this situation? I can reduce my records but dont wat to if possible. Any other suggestion for ranking these many records? thanks SKV
  17. P

    Relative Ranking Formula

    This is for a school. I need to rank the students based on family information. FamilyID = one ID per family StudentID = unique student ID Grade = student's grade TeachingFamily = binary, do they have a parent who teaches at the school Status = are they a Full Time or Part Time? (not binary, as...
  18. G

    Excel and/or Access ranking questions

    Thanks in advance for taking the time to read this! I have a rather large data set, containing over 20,000 records and I am looking to calculate the percentile ranking of 10 to 20 different statistics for each record, in each category, if the statistic exists. Of these 20,000 records, I...
  19. J

    Rank a column by a given average

    Hello all! So I am trying to rank a column of numerical data by a given average of the cells: Assume, Column "D" is: <table width="86" border="0" cellpadding="0" cellspacing="0"><col style="width: 65pt;" width="86"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22"...
  20. M

    CHALLENGE FOR an EXCEL WIZ

    Hi Everyone, Here is my challenge. It may sound easy but I have not been able to find a solution as of yet. I am creating a template so that when I upload data it auto populates and I have little work to do. Here is my problem: I have a list of Sales and wish to rank them (easy...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top