Comments on: MAX function in Excel: formula examples to find and highlight highest value

MAX is one of the most straightforward and easy-to-use Excel functions. However, it does have a couple of tricks knowing which will give you a big advantage. Continue reading →

Comments page 2. Total comments: 134

  1. I have a data on Matrix and I also have the criteria data in Matrix as well See below

    Data from the Matrix

    Period 0.0 30 45 60 75 90 105 120 135 150 180
    6.0 0.356 0.443 0.469 0.505 0.579 0.525 0.516 0.475 0.342 0.271 0.171
    7.0 0.439 0.541 0.558 0.678 0.802 0.642 0.747 0.499 0.436 0.336 0.232
    8.0 0.505 0.544 0.591 0.694 0.759 0.747 0.736 0.584 0.560 0.467 0.269
    9.0 0.489 0.614 0.618 0.630 0.791 0.687 0.631 0.577 0.507 0.562 0.340
    10.0 0.538 0.603 0.572 0.580 0.703 0.643 0.619 0.556 0.489 0.459 0.399
    11.0 0.503 0.491 0.513 0.578 0.585 0.630 0.587 0.542 0.439 0.459 0.345
    12.0 0.517 0.446 0.539 0.588 0.546 0.564 0.552 0.497 0.411 0.412 0.355
    13.0 0.470 0.439 0.545 0.534 0.530 0.482 0.510 0.470 0.422 0.404 0.329
    14.0 0.399 0.427 0.469 0.442 0.462 0.434 0.409 0.425 0.382 0.395 0.340
    15.0 0.370 0.390 0.388 0.397 0.421 0.393 0.355 0.387 0.355 0.341 0.331
    Criteria for the matrix

    Period 0.0 30 45 60 75 90 105 120 135 150 180
    6.0 3 5 5 6 7 6 6 5 3 2 0
    7.0 5 6 7 9 10 8 10 6 5 3 1
    8.0 6 6 7 9 10 10 9 7 7 5 2
    9.0 6 8 8 8 10 9 8 7 6 7 3
    10.0 6 7 7 7 9 8 8 7 6 5 4
    11.0 6 6 6 7 7 8 7 6 5 5 3
    12.0 6 5 6 7 6 7 7 6 4 4 3
    13.0 5 5 6 6 6 5 6 5 4 4 3
    14.0 4 5 5 5 5 5 4 5 4 4 3
    15.0 4 4 4 4 4 4 3 4 3 3 3
    Is there any way to find the maximum of no 3 or 10 from the criteria data on the criteria Matrix, and the max values should be taken the matrix data based on the location from the matrix criteria ?

    So from the above No 10 should be the maximum from Matrix ( [7,75] or [7,105] or [8,75] or [8,90] or [9,75] )?

    Thanks for your help and taughts

  2. I like it

  3. I need to get the list of highest defect type from the product type of highest defect contributor with list of data below.

    Process Type Total NG Input Output Defect 1 Defect 2 Defect 3 Defect 4 Defect 5
    A AA 10 20 10 5 5 0 0 0
    A AC 15 20 5 0 7 8 0 0
    A AD 12 20 8 0 6 2 4 0
    A AB 10 20 10 3 3 4 0 0
    A AD 10 20 10 0 5 5 0 0
    A AG 10 20 10 0 0 5 5 0
    B AF 16 20 4 0 10 3 3 0
    B AC 13 20 7 0 0 6 7 0
    B AR 10 20 10 0 0 4 6 0
    B AD 10 20 10 0 0 0 5 5
    B AB 10 20 10 0 0 0 5 5
    B AR 10 20 10 0 0 5 5 0
    C AJ 12 20 9 0 0 6 6 0
    C AS 10 20 10 5 5 0 0 0
    C AF 10 20 10 0 5 5 0 0
    C AA 10 20 10 0 0 0 5 5

    Where Output data should be like this

    Process Type Total NG Input Output Highest Defect Quantity Highest Defect Type
    A AC 15 20 5 7 Defect 2
    B AF 16 20 4 10 Defect 2
    C AJ 12 20 9 6 Defect 3
    C AJ 12 20 9 6 Defect 4

    Thank you for the response

    1. Hi!
      I don't really understand how you want to create a list. For example, why is it missing B AC 13 20 7 0 0 6 7 0. I don't think it's possible to do this with a single formula. Perhaps this guide will be helpful: How to get matches of largest N values.
      If you have a specific question about the operation of a function or formula, I will try to answer it.

  4. I scourged the net and found this helpful, but ran into a dead end. I have a spreadsheet that has incidents in other.

    Sheet/tab #1: Overview tab of all collected incidents, with the latest comment copied/paste from the other tabs.
    A2: Incident #, B2: Date Reported, C2: Status, D2: Latest Comment

    Sheet #2: has information on the all the information on this incident 2 by date (A2:A100) including latest comments all in column D.
    A2: Date, B2: Assignee, C2: Updated by, D2: Comment

    Sheet #3: same as #2
    ...etc...

    Each sheet is named the Incident Number. So for example, incident "#2" is also the same name of the reference sheet "#2".

    As the incidents are growing, I need to automate this to pull the max date's "Comment" from each sheet directly to the overview sheet #1 corresponding to that incident # in each row (D2). Currently I'm manually updating D2 Comment cell's formula's sheet reference:

    =VLOOKUP(MAX('#2'!$A$2:$A$100),'#2'!$A$2:$D$100,4,0)

    which is becoming tedious. Is there a way to automate pulling from the sheets (e.g. #2, #3, etc.) other than manually naming the sheet reference in the formula? I tried to concatenate '#2' to pull from A2 but that didn't work.

    Any help is greatly appreciated!

      1. You probably already know this, BUT you're a genius! Got it working!**

        I guess I was just off by missing a few small things. In case anyone else needs it:

        =VLOOKUP(MAX(INDIRECT("'"&A2&"'!A2:A100")),INDIRECT("'"&A2&"'!A2:D100"),4,0)

        Again, you guys are awesome!!!

        TLDR:
        **this works off my master list that pulls my comments (in column 4) from other sheets. The master references list is written in cell A2 (with the sheets/tab being the same name), and then looks at the max date in cell A2:A100, from the table A2:D100, pulling back the latest comment listed in column 4.

  5. I have a spreadsheet to hold a series of quiz results
    Quiz Number of questions Contestant 1 Score Fractional score Max Score
    1 40 25.5 0.6375 18
    2 30 17 0.566666667
    3 20 18 0.9

    I want a formula that calculates the "Max Score", based on the highest "Fractional Score". To calculate "Fractional Score" I divide the actual score by the number of questions.
    I can calculate "Max Score" using
    =INDIRECT("C"&MATCH(MAX($D:$D),($D:$D),0))
    In the sample the "Max Score" is 18 ie the value in Column C where the highest value of "Fractional Score" occurs.
    I want to do this without showing or using the "Fractional Score" column. I have tried such things as:
    =INDIRECT("C"&MATCH(MAX($C:$C/$B:$B),$C:$C/$B:$B,0))
    but it shows #N/A.
    Would you be able to help?

    1. Hello!
      If I understood you correctly, then you can use INDEX MATCH to find Max Score.

      =INDEX(E1:E3,MATCH(MAX(C1:C3/B1:B3),C1:C3/B1:B3,0))

      Hope this is what you need.

      1. Hi,
        Thanks for that! I needed to replace "E1:E3" with "C1:C3" and enter it using SHIFT/CTRL/RTN, but it works perfectly. I now need to figure out how I can use whole column references (eg "C:C" rather than "C1:C3") so that I don't have to edit it every time a new row is added.
        Thanks again.

  6. I have a data table with datewise sales. each date has lot of number of transactions. I want to find a date and value of sales with highest value (Highest value of sales in a day)

  7. I'm trying to calculate my students' grades. They take 4 exams. The highest (max) is weighted a bit more than the other 3. So, I'd like to create a function to identify the max of the 4 #s, multiply it by .2, and then take the other 3 #s and multiply each by .15, and then add them all together. I appreciate your help!

    1. Hi!
      If I understood you correctly, determine the maximum value using the MAX function and subtract it from the total grades.

      =MAX(A1:A4)*0.2+(SUM(A1:A4)-MAX(A1:A4))*0.15

  8. Hello Everyone,

    How to automatically find the amount using the cut-off date?
    just so happened no dates for 01/31/2021, instead, the date before that could be taken
    Result must be 700.00

    Cut-off Date: 01/31/2021
    Amount: ?

    Date Amount
    12/31/2020 1,000.00
    12/31/2020 700.00 (this must be the result)
    02/28/2021 900.00
    04/14/2021 800.00
    04/30/2021 1,200.00
    05/14/2021 500.00
    06/30/2021 600.00

    I cannot find the right formula, pls help me do it correctly.
    thank you very much.

  9. I have cell address written in text. Would like to know how to find the max value from the defined addresses.
    Example:
    Cell A1 input text as $C$56
    Cell A2 input text as $C$12356
    Would like to find max($C$56:$C$12356)

    Instead of selecting the cell range manually, the formula should success based on the text input in A1 & A2.

    1. got the solution. Using indirect().
      Max(indirect(A1):indirect(A2))

  10. Hello!

    In one of the data's column (let's say it's "A") I have DATE information (formatted like this: 03/14/01) and in the other column (let's say "B") I have PERCENTAGE value that changes based on some other data. Now, what I'd like to obtain is to have a MAXIMUM value of the PERCENTAGE column based on any given MONTH (January, February, March and so on). For example: what is the maximum percentage value for a month of January or February or March, etc..?
    Can someone please help me with a formula here?

    Thank you,
    Julia

  11. Hi,
    I am trying to return the Highest value from the below row considering the condition if A>B>C>D. The formula should return the highest value meeting the condition.

    A Approved
    B Approved with Comments
    C Resubmit
    D Rejected

    A>B>C>D

    D D C C C B B B A A "=FORMULA"

    1. Hello!
      If your values are written in separate cells, then you can extract the desired letter using the INDEX + MATCH formula:

      =INDEX(B2:K2,MATCH(MIN( MATCH(B2:K2,{"A","B","C","D","E","F","G","H","I","K","L","M", "N","O","P","Q","R","S","T","U","V","X","Y","Z"},0)), MATCH(B2:K2,{"A","B","C","D","E","F","G","H","I","K","L","M", "N","O","P","Q","R","S","T","U","V","X","Y","Z"},0),0))

      1. Hi,
        I got the solution by below formula:-

        =IFERROR(CHAR(MIN(CODE("A"),CODE("B"),CODE("C"),CODE("D")),"")

        Thanks for your help .

  12. RANDUM NUMBER ENTRY STOCK PICK THIS RESULT
    65.500 12.5+12.5+24.5+30+70+65.5 12.5+12.5+24.5+30

  13. I have a spreadsheet that calculates used/monthly accrued vacation time based on hours and minutes.
    Example: Hours/Minutes total for May shows 150:10 (the formula used to arrive at this figure is =SUM(F6-B7+E7). I need to add or edit this formula to tell it to max out and never exceed an accrual of more than 283:30. I tried =MAX(F36-B37+E37,&TIME(“283:30,0,0”), but that was not successful. Do you have any suggestions?

    1. Hello!
      With the TIME function, you cannot set the time for more than 24 hours. Convert your time to days with this formula
      =283.5/24
      If I understand your task correctly, use MIN function and try the following formula:

      =MIN(F36-B37+E37,283.5/24)

      1. That worked! Thank you.

  14. Can I use the MAX formula on a cell range that uses IF formula's to display a number?

    Ex.
    2 Mild ("2" is displayed using [=IF('Severity Rating'.I3="Yes";"2";"0")])
    3 Moderate ("3" is displayed using [=IF('Severity Rating'.I4="Yes";"3";"0")])
    4 Severe ("4" is displayed using [=IF('Severity Rating'.I5="Yes";"4";"0")])

    I want to create a function to identify the max number (4 in this case) and sum all the severity ratings in each category (the above is just one category). The IF formula identifies if Mild, Moderate, or Severe ratings were indicated by the client, but I don't want to add all of them, as that would be inaccurate. There are 5 separate categories with 20 being the highest score possible. I only want to sum the highest number displayed in each category.

    Hope that makes sense! Thanks for any help you can offer!

    - Catinreno

      1. Except apparently that won't work in open office Calc. Any other options?

          1. In Excel, what would the formula for this look like? From what I am understanding, the Max_range & Criteria_range1 are identical?? And then what would be the criteria1?

            Here's the list again for reference (It looks like I might have accidentally deleted the first row in my first post):
            1 Absent ("0" or "1" is displayed using [=IF((AND('Severity Rating'.I3="No",'Severity Rating'.I4="No",'Severity Rating'.I15="No")),"1","0")])
            2 Mild ("2" is displayed using [=IF('Severity Rating'.I3="Yes";"2";"0")])
            3 Moderate ("3" is displayed using [=IF('Severity Rating'.I4="Yes";"3";"0")])
            4 Severe ("4" is displayed using [=IF('Severity Rating'.I5="Yes";"4";"0")])

            Thanks again.

  15. Heya! I'm trying to create a football playoff scores tracker/spreadhseet, and I want to answer the following question: 'Out of this column of scores, what is the highest score?' Except, I need it to return the team name (adjacent to the cell containing their score), not just the highest number. I grasp how to use the max function for this, just not sure how to extend it to return a different field.

    Thanks!

      1. Can you please be more specific on this. where to use that formula?
        I have a sheet to record performance. So names, in column A, then figures for each day of the week in B to F. I've got the highest values for each row selected in column L, but now i Struggle to sort them in order, so names and the highest values respectively, in highest to lowest order?

  16. Hi, I am trying to find the max value in cells containing letters in the beginning and numbers aftewards. i.e AB22002, CC22021, CB22003. Can I get the max of the numbers only. I am trying to avoid to have to split them in different cells.
    Thanks,
    Tony

  17. Hello! How to find the highest number using the IF condition?

  18. Hello,
    I would like to count the the latest date in each row (spanning columns B through F) that are equal to or less than another date in a separate row (Column A). I though maybe the Max feature might be helpful. Am a bit frustrated. What I am trying to do is retroactively count (based on a specific date in Column A) the number of students that had attained various levels of academic achievement (signified by Levels 3,4,5 etc) by that date is Column A.

    1. Hello!
      To conditionally count, use the COUNTIF or COUNTIFS function. You can find examples and detailed instructions in this article. I hope I answered your question. If this is not what you wanted, please describe the problem in more detail.

  19. how to find a maximum items?
    like in your example here I want to get the highest cost fruit if it is grapes,lemon, apple
    I want a function that writes a word (which is items in your example) not a number.

    thank you!

    1. Hello!
      To select the product with the maximum price from the list, use the INDEX+MATCH functions

      =INDEX(B3:B8,MATCH(TRUE,$C$3:$C$8=MAX($C$3:$C$8),0))

      I hope I answered your question. If something is still unclear, please feel free to ask.

  20. im trying to find the best way to write a function that will take the max of a range of cells and display the row header associated with that cell... for example take the Max of cells A1:a17 and display the row header of whichever value is produced from the max function. any input?

    1. Hi!
      Your question is not entirely clear. What row title do you want to show? What cells is the row header in?

  21. Is it possible to do an index match lookup between 2 tables and also find the highest value? The index match + max formulas I am finding all seem to be for within a single table.

    For example, if you have a list of cities and hotel prices at different times of the year in one table.
    Then in another table, you have a list of cities, with columns for different values and you want to pull in the highest hotel price from the other table. Is that possible with any kind of lookup?

  22. Hello,
    I have tried my best on my own forever. I am trying to get the largest sum of 5 numbers, however, based on a second column, the corresponding total cannot exceed a number. Example, for the below, I would like to have the left column total the largest of the 5 added up, but cannot exceed $135 based on the column to it's right. I have gotten close, but it will give me a number but don't actually know which 5 it has chosen! Ha. So best case scenario, it will highlight or say A, D, H or whatever are the five that total the most without going over $135 summed on the right column. Thanks for any help and I hope that makes sense.

    A 24.91 $37
    B 19.47 $23
    C 18.26 $38
    So On 17.27 $34
    13.48 $22
    12.37 $18
    11.45 $20
    10.68 $18
    9.49 $17
    9.34 $18
    8.99 $16
    6.25 $10
    6.15 $21
    5.38 $10
    4.28 $10

  23. I have a customer list with three columns representing stage1, stage2 and stage3. some customers have balance only in one stage while others have balance in two stages. I want to find out the stage with maximum balance for each customer. how to find the same.
    Customer STAGE1 STAGE2 STAGE3 Result I want
    ABC 100 400 STAGE3
    DEF 3000 2000 STAGE1
    MNO 5000 50 STAGE2
    KPL 250 STAGE1
    GHI -250 STAGE2

    How can I find the result with a formula for larger amount of data

    1. Hello!
      The formula below will do the trick for you:

      =INDEX($B$1:$D$1,MATCH(MAX(B2:D2),B2:D2,0))

      You can learn more about searching with INDEX + MATCH in Excel in this article on our blog.

  24. I have 2 columns of values, i have conditionally formatted each to show top 20%. I want ones that are in the top 20% of each category to be highlighted in another colour. e.g top 20% in column A Green, top 20% in column B Green. In top 20% in A and B Blue.

    Any assistance is appreciated

    Thanks,
    Luke

  25. After I find the MAX value, do I use a CONCATENATE formula to show which is the highest value? Any suggestions are welcome. Thank you.

  26. i have in
    column A: 34,34,34,33,33,33,35,35.
    column B: 3,2,1,5,4,3,2,2,1

    what function i can use to gate max value of B compare to A: 34,33,35 for each
    like in column C: 3,nil,nil,5,nil,nil,2,nil.

  27. I have been trying the formula to get headers to find maximum value in rows which goes as =INDEX($P1:$R1,0,MATCH(MAX($P2:$R2),$P2:$R2,0))
    I drag the formula through the column. It takes the 2nd row values as headers. The formula seems as =INDEX($P2:$R2,0,MATCH(MAX($P3:$R3),$P3:$R3,0)). It returns the 2nd row maximum values in the consecutive cells but not headers for the maximum value.

    How can I fix this issue that the header reference formulas do not change in the formula?

  28. Hello im trying to find the best formula for this data. I feel it should be FILTER but not sure which one to use.
    I need to filter the result in column D with the condition as
    amount = highest value in Column C
    data limited to column B of Company XYZ

    expected result should be: A9100 amount$3,428.52

    please help.. I'm not expert in excel's formula. thanks in advance..!!

    A B C D
    Company XYZ AC1000000454 $3.59 A1019
    Company XYZ AC1000000454 $67.91 AR400
    Company XYZ AC1000000454 $3,428.52 A9100
    Company XYZ AC1000000454 ($353.20) AF400
    Company XYZ AC1000000454 ($33.00) AHF00
    Company XYZ AC1000000454 ($4,256.00) A1044

  29. Hi,

    Could you please help me out on how to calculate max time from an array of 3 time stamps of 3 systems placed horizontal in range? How can I get the system names too after I try the formula or it can directly show system names that has highest time? How can I use maxifs with criteria range?

    System 1, 00:30:23
    System 2, 00:57:20
    System 3, 00:11:05

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

      1. Hi,

        The 3 time stamps are placed horizontal on a row.

        A. B. C
        00:30:23. 00:57:20 00:11:05

        How can I get max value from the columns A,B,C with names system 1, system2 and systems 3 respectively in formula? Please help me out on this.

        1. Hi!
          Have you tried the ways described in this blog post? If they don’t work for you, write what formula you used and what were the problems.

          1. How can I get any of the three systems names whichever with maximum value on a single column with respect to 50 rows for 3 systems?

          2. Hi,

            I have tried with index, match, max functions.

            If I have headers : System1, System2, System3 in Column O, P, Q with 00:01:57, 00:04:00, 00:00:35 timestamps respectively.

            And there is a list of 50 timestamps under each.
            I want to find out which system has maximum timestamp value.

            I tried the formula, on 2nd row:
            INDEX($O1:$Q1,0,MATCH(MAX($O2:$Q2),$O2:$Q2,0))

            Problem1 : I don’t get the true system header name with true maximum value.

            Problem 2: the formula doesn’t work on 3rd row when I try to drag the formula for next 50 rows.
            Please suggest.

            1. Hello!
              If I got you right, the formula below will help you with your task:

              =INDIRECT(ADDRESS(1,MIN(IF(O2:Q51=MAX(O2:Q51),COLUMN(O1:Q1)))))

              This is an array formula and it needs to be entered via Ctrl + Shift + Enter, not just Enter.

              I hope it’ll be helpful.

  30. Hi

    Am working with data where I have to get the date of Highest Quantity with matching Product No.
    Maxif formula is not working with.

    Kindly suggest the way out.

    Product Qty Date
    GHI 102 30-Aug
    DEF 77 30-Aug
    ABC 21 30-Aug
    ABC 10 30-Aug
    GHI 119 20-May
    GHI 106 20-May
    GHI 94 20-May
    DEF 81 20-May
    DEF 69 20-May
    DEF 56 20-May
    ABC 44 20-May
    ABC 36 20-May
    ABC 10 20-May
    GHI 114 10-May
    DEF 90 10-May
    DEF 65 10-May
    ABC 40 10-May
    ABC 20 10-May
    GHI 110 01-May
    DEF 85 01-May
    DEF 61 01-May
    ABC 35 01-May
    GHI 123 30-Apr
    GHI 98 10-Apr
    DEF 73 10-Apr
    ABC 48 10-Apr
    ABC 30 10-Apr

    Result should be - ABC - 10-Apr (ABC highest Qty is 48 so 10-Apr)

      1. Hi

        Date format is correct.
        Have tried {=MAX(IF($B$3:$B$29=$G6,$D$3:$D$29))}
        This gives me latest date against ABC which is 30-Aug.
        I would like to have result 10-Apr because ABC has 48 (highest Value)

        1. Hello!
          I believe the following formula will help you solve your task:

          =FILTER($D$3:$D$29,($B$3:$B$29=$G$6)*($C$3:$C$29=MAXIFS($C$3:$C$29,$B$3:$B$29,$G$6)))

          You can learn more about FILTER function in Excel in this article on our blog.

  31. Hello,

    Does anyone know how to apply this function with data that is not in a consecutive range?

    Instead of a range like B5:G5, my data is B5,D5,F5,

    Can anyone help?

    Thanks!

  32. Hi,
    I have a data sheet that I need to extract information from, in one column I have the NAMES of persons, in another I have either "yes" or "no" answers for each person.
    I'd like to extract everyone's name who answered "yes" into either one cell, separated by commas, or each into a vertical list.

  33. Hi, I am involved in stock trading and i have my trading records in Excel; ie bunch of profits and losses.

    My question is, how do i find the lowest and highest profit and loss that i make in my records?

    =MAX(IFERROR(P23:P79, "")) + CTRL + Shift + Enter only return highest profit, while
    =MIN(IFERROR(P23:P79, "")) + CTRL + Shift + Enter returns highest loss.

    How do i find lowest profit and lowest loss? Where can i fit the criteria "0" ?

    Do note that i have multiple blanks (intentionally left) and #DIV/0! (formula i keyed in in advance for future trading but i havent filled in respective fields)

    Thank you in advance. God bless and have a nice day.

  34. Hello, I'm trying to get the maximum error to show up but some times the maximum error is a negative (so -5 is a greater error than +3 etc) Any ideas?

    Also the 2 cells I'm comparing arent next to each other (just to add to the fun).

  35. hello
    Can I get help to write a formula that will highlight the lowest price for an article that repeats in several rows. If that article only shows once then that price would be highlighted too. for example only the first line would be highlighted.

    article 1 300
    article 1 548
    article 1 2500

    Thank you for your help

    1. Hello!
      I recommend using the FILTER function to find the article you are looking for. Find the minimum price using the MAXIFS function.

      =FILTER(A1:B8,(A1:A8="article 1")*(B1:B8=MINIFS(B1:B8,A1:A8,A1:A8)))

      I hope my advice will help you solve your task.

  36. I'm struggling with this a bit.
    My challenge is that I've got a list of results in a column, and want to identify the largest value in that column and then add a bonus prize in the next column for the largest row value.

    I would describe it BADLY as:
    in the column next to the data: +IF("the data in this cell is greater than the cells in rh column, give me A point" otherwise 0)
    Does that make sense?

    thanks

    1. Hello!
      In the next column, you can write the formula

      =IF(MAX($A$1:$A$30)=A1,100,"")

      After that you can copy this formula down along the column.
      Hope this is what you need.

  37. I am trying to find a formula that returns for example to find which State had the highest sales for a specific month. Column A is the State and Column B is the sales for the specific month. Does anyone know a formula for this? Thanks.

      1. Well if my range is - A2:D10 and I need to find the highest value with the name the person

      2. Thanks it worked.

  38. Hi, is it possible to create a formula to find the max value if some of the cells contain ranges please?
    i.e. working out that the max value is 505 from the following cells:
    Cell 1. 490
    Cell 2. 500,
    Cell 3. 490-505

  39. Dear Sir

    can you help me to do a formula to find highest value of 1st numbers letters

  40. This is excellent, thanks for saving me a ton of time!

  41. which one of the following functions is designed to display the maximum value in a range of cells with question answer

  42. THANK YOU!!! Do you know how complicated I have been making this for years?! And it was as simple as =Max!!!
    You have made my day!

  43. How to find max, 2nd, 3rd & 4th latest dates by name in another sheet?
    Results e;
    Names in column A
    Dates in column B
    Distance in column C
    & so on

    Regards
    Tony

  44. Well nd easy

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)