large formula

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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"...
  7. 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...
  8. 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...
  9. 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...
  10. 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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top