large formula

  1. Z

    Ignoring Blanks and get top 20

    Hi, I managed to use below formula to ignore blank and it worked, what I need now is how to get the top 20 or any top (any figure). I'm using below table as an example data: Formula I used : =UNIQUE(SORT(FILTER(Sheet1!$CQ$15:$CS$7241,Sheet1!$CR$15:$CR$7241<>""),3,-1)) Real data range in my...
  2. Z

    Top 25 Companies

    Hi, I have a monthly/quarterly report that shows top 25 companies that we gained employees from. What I need to build a dynamic list that can be refreshed whenever I dump the updated data file and formula can be refreshed to update my list. I know using some formulas like rank, filter and other...
  3. J

    Large Formula with Index Match by Criteria

    Hi, This is the first time I've posted here so apologies if any of this is incorrect. I have a list of products ordered by week with their volume. I would like to select the top ten products by week. I have found and used the formula which gets the top ten, but I am struggling to do it by...
  4. B

    How Can I Average Values based Top 5 Values in another column?

    I have been trying to figure this out for a few days and haven't been able to find anything online with this exact situation. I have a large set of data (~5000) with names of individuals, dates of completion, and scores assigned. I have figured out without too much difficulty how to average all...
  5. J

    Excel find closest bigger value in a column to a given lookup value

    I am going to input data in A2:A100. Based on a formula, a calculation is made and returns results in J2:J100. The lookup value is in cell P2. There are cells in column J that are currently displaying "#DIV/0!", due to the fact that there are cells in column A that have not been filled yet. I am...
  6. C

    Find top 10 larget value from the list

    Hi Friends, New to Mr. Excel Forum. searched many blog but not reached to the solution. please help. Query; <tbody> Sheet: DATA Sheet: Result a b c a b c 1 month emp code collection 1 Rank Jan Feb 2 jan a1 500 2 1 a1 a2 3 jan a3 500 3 2 a5 a3 4 jan a5 1200 4...
  7. Fishboy

    Reporting top 5 values - duplicates causing issues

    Hi all, In Excel 2010 I have a table of information containing sales of items. On anther tab within the document I am creating a dashboard with an overview of the main information people want to know. In the 'Sales Sheet' data table I am reading from I am interested in the following columns...
  8. S

    Lookup 1st , 2nd , 3rd Maximum value

    <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Data Names SKU1 SKU2 SKU3 SKU4 SKU5 Ali 0 20 15 0 0 Butt 15 0 16 30 Adnan 0 25 15 10 15 </tbody> <colgroup><col width="64" span="2"...
  9. F

    Returning the Sheet Name using =LARGE formula across multiple worksheets

    I have a workbook with multiple sheets. I am using the following formulas to find the 3 largest numbers in a defined cell across each sheet (L12). I need to return the name of the sheet as well. number will change, and I need the sheet name to be variable based on what the formula pulls in. Any...
  10. P

    Nesting the large formula inside a cell formula

    Hey, Needed some help with nesting some formula. Suppose I have a row like this: <pre> A B C D E F 1 apple mango orange guava banana 2 2 4 1 5 5 </pre> a) Now, if I want to return the...
  11. D

    Large function doesn´t include negative numbers

    Hi, I have a table like this A B C D E <TABLE style="WIDTH: 339pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=452 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL...
  12. S

    help with the Large formula

    Hi, hoping somebody here can help. I am trying to calculate the top 3 values in a range of 6 values and sum them. I was using the large formula =Large(E134:J134,1)+Large(E134:J134,2)+Large(E134:J134,3) and that was working excellently until I hit a snag. Basically sometimes there might only be...

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
Top