min value in range

  1. M

    Finding MIN date in a range of incomplete data

    Hello, I am having difficulty finding a solution to make a range dynamic. I found my total row by using MATCH("Totals:",A2:A100,1)+1). Because I want to add addtional rows to the range (up to 100), I want to find the MIN of that range and I tried using this formula: MIN...
  2. G

    VLOOKUP function finding MIN value

    Hi, I got 2 columns I want to calculate the minimum value corresponding each number 1 and 2. I don't know how to put the min function in it. =VLOOKUP(C1:C2,A1:B11,2,False) 1 0.01 1 1 0.00 2 1 0.04 1 0.09 1...
  3. cvincent

    Highlight Min value in range greater than

    I have a column of percentages, and need to highlight the smallest value that is greater than 80%. This report is updated daily. I would like to know how to set conditional formatting to do this, or at least have a formula or run a macro to do this.
  4. R

    mimimum of dates with if statement

    Hi Everyone :) Having trouble putting the following statement together. I have various dates in column A and column B with some blanks mixed in. I need a statement in column C that will show the earliest date between column A & B. If both columns are blank then I need a return of: "Still in...
  5. D

    Max or min only if matches date

    How do you get a maximum or minimum number based on two criteria (MAX or MIN if within date specified)? DATE (Column A) ---- NUMBERS (Column B) ---- MAX OR MIN OF SPECIFIC DATE (Column C) 12/1/2010 -------- 30.00 ------ Maximum for 12/1/10 is: ? 12/1/2010 -------- 30.10 ------ Minimum for...
  6. D

    Find Smallest Non-Zero Value in Column

    Hi, Having a difficult time finding the difference between the maximum number and the smallest non-zero value that ignores text and any error messages. What I need to do is subtract the Maximum value in the column from the smallest non zero value. In the case below, it should take 7 minus 5...
  7. R

    find min value depending on range

    Hi I need to find the minimum value in row 2 for each account in row 1, for example row 1 row 2 111 50 222 20 333 80 444 40 111 40 222 50 Results would show 111 with a minimum value of 40, 222 with a minimum value of 20 etc etc I would prefer a formula that...

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