top 5 rank

  1. L

    Dynamic Arrays - Top 5 values

    Hi! I am having some difficulties with my dynamic arrays I need to create two different dynamic arrays, in which I extract the Top 5 values aggregated by "Case". In the first scenario, I would need to obtain the Top 5 values when...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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"...

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
Top