top 5 rank

  1. B

    Recap Top 5 Sales Data With Formula Only

    I am looking to recap some data using formula or vba only, so the end user doesn't need to know how to use pivot tables, sort, etc. Can someone help with some formulas that would do the following for Excel 2003 and later versions? Thanks!! I have a simple table of Customers and Sales similar...
  2. P

    Rank by sumifs (To Get unique rank count to each line)

    Hello Experts, CASE: I have Five projects but having different revenue generation for each, So I need to find out the best project by Cumulative Revenue and give them the rank (1 to 5). Requirement: Want to get Ranking from 1 to 5 against each project based on their cumulative Revenue without...
  3. D

    TOP 5 From Multiple Rows

    <tbody> Labour Cost Cleaning 200.58 Travel Time 489.56 Wet Time 55.00 Set- UP 855.00 Operating Equipment 780.00 Spotter 200.00 Supervision 1200.00 </tbody> I need a formula that gives me the top 5 values in Col B and then Displays them with the appropriate Value in Col A As such...
  4. L

    Rank Top 5 Customers in a list by the sum of revenue

    I've gone through and done my legwork to try and find this online after trying many different methods that I know. This is the first one that I can't get an answer for by looking online. It seems easy enough to do. I'm trying to not use a pivot table and have a dashboard to rank the customers by...
  5. F

    Filter Top 5 of Filtered Data

    Hi! I have been trying to retrieve the top 5 entries by revenue after filtering using an industry category. The problem I'm facing is that the top 5 filter seems to assume that I want the data that is not captured by the first filter so I am left with "missing" data which is supposed to...
  6. M

    Subtotal function to pull top 5 values

    I am trying to pull the top 5 values from a list. The problem is the list has subtotals throughout, which I do not want to pull. Is there a way to use the Subtotal(4,range) function to select the top 4 items. I'm trying not to create a new column for ranking. Thank you.
  7. N

    how to rank top 5, then copy into new column

    Hi, Please help me how to top 5 this data, and then copy into new column. A.) This is main data. <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=256 x:str><COLGROUP><COL style="WIDTH: 138pt; mso-width-source: userset; mso-width-alt: 5888"...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top