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