max and min

  1. S

    Min and Max Functions returning a 0 value when looking up a formula

    Hi, I have the following formulas in cells FQ3 and FR3 which return the numbers 16 and 19 repsectively =IFERROR(LEFT(INDIRECT(FQ$1&$DZ3),(FIND("-",INDIRECT(FQ$1&$DZ3),1)-1)),"") =IFERROR(RIGHT(INDIRECT(FQ$1&$DZ3),(FIND("-",INDIRECT(FQ$1&$DZ3),1)-1)),"") However I then want a formula that...
  2. A

    Working out Extra hours with a limit

    OK i have been racking my brain about this for far too long, hopefully someone here can help me What i need is a formula that will tell me how many extra hours someone has worked over their contracted hours, So the Min would be their Contacted Hours Per Week * 4 (32*4=128) the Max would be 160...
  3. A

    MAX(IF and MIN(IF not giving results expected

    Hi all, I have created a MAX(IF command in order to find the maximum temperature, from a table, between two times. it looks like this: <h5,c16:c28226,0)))}, and="" it="" works="" great! <h5,c16:c28226,0))) <h5,c16:c28226,0))) <h5,c16:c28226,0)))...
  4. M

    Refreshing web query creates #N/A in referencing cells

    Hi, I have a worksheet with one tab that has a web query retrieving data from an online table and another tab that uses a series of formulas that start by referencing the tab with the web queries. The order of the formulas is as follows: web query --> cells referencing the table created by...
  5. J

    If Greater than this column and this column then Max and Min and display this cell

    <tbody> NAME A B C D 0% 1 561 91% 2 560 86% A 0% </tbody> If Column A is Greater than 0 and Column B is greater than 90, then find the MAX of column B, and display Name Cell. It should give you (1). Also the same as above but instead of MAX I need the MIN...
  6. J

    If this is the MAX In one column then put this from another column

    <tbody> Column1 Column2 2 150% 3 100% </tbody> How do I write, get the MAX value from column2 and Display the name for column1 to another cell in a formula? So the answer should be (2) This is only based on the max value and nothing else.
  7. J

    Conditional Formatting to find highest value in a ROW if greater than n% to the second highest and also finding the lowest value in a ROW if n% lower

    Hi All, Hope you're all well. I am trying to do the following, if possible. I have found a way around it using formaulas but can't do it using conditional formatting. What I want to do is to find highest value in a ROW if greater than n% to the second highest (say green) and also finding the...
  8. M

    Get the max and min based on certain criteria

    Please help me look for a formula to get the Max and Min value based on given criteria. <tbody> Client Campaign Name Sent Unique Opens Opens rate Product1 Campaign1 20 14 70.00% Product1 Campaign2 18 11 61.11% Product1 Campaign3 10 8 80.00% Product1 Campaign4 9 6 66.67% Product1...
  9. M

    Get the Max and Min Value based on criteria

    Please help me look for a formula to get the maximum and minimum value based on certain criteria. Thanks. <tbody> Client Campaign Sent Unique Opens Opens rate Product1 Campaign1 20 14 70.00% Product1 Campaign2 18 11 61.11% Product1 Campaign3 10 8 80.00% Product1 Campaign4 9 6 66.67%...
  10. N

    Find Typical Values with Vlookup including Max Min

    Hi, Dear Experts i found in typical vlookup situation. i use vlook up function but i can't use with other functions please advice me on this illustration. <TBODY> ID #</SPAN> Students</SPAN> English</SPAN> Physics</SPAN> Chemistry</SPAN> Biology</SPAN> Computer</SPAN> Social...

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