1. C

    IF/MAX/MATCH formula required

    A B C D E F G H 1 week 1 week 1 week 2 week 2 week 3 week 3 2 W R W R W R WB RB 3 25 10 30 8 30 12 30 FIND THIS NUMBER I have a table of data that looks like above. I have used MAX function to find the highest occurring number in cells labelled with "W". In cell H3, I want to find...
  2. jase71ds

    An Elegant Solution to Setting Evaluation Constraints

    This isn't a question - just wanted to share a solution I came up with. Others have probably come up with the same solution, but I was pleased with myself for figuring it out on my own. Plus, it was fun! If I want to constrain a formula output, say between +100% and -100%, one popular way to do...
  3. A

    Use of LARGE, SMALL, MAX, MIN, SUM Functions in spilled arrays

    Hi all, I would like to use functions like LARGE, SMALL, MAX, MIN and SUM in spilled arrays and get the values PER row instead of the total. For Example: x y =MAX(A2:B2) dragged down =MAX(A2:B5) 1 2 2 8 3 4 4 5 6 6 7 8 8 The only solution I...
  4. M

    Replacing OFFSET to sum up to max value from specific cell

    Hello everyone, I am new to the board & thank you all in advance for the help. I have data for the time it takes each step in a manufacturing process & each step has a unique name that never repeats, as seen below, pasted in A1 corner. Steps time Start Point Sum of Steps Count 2800N1 5...
  5. U

    Return Max Value of Column X after Vlookup of Column A

    Hello, I have a workbook with 2 sheets, "ProgramMasterList" and "urslabs". I'm trying to lookup the latest Date in column M in sheet "urslabs" and match the values into sheet "ProgramMasterList" in column V using column A as the lookup value in both sheets. I'm using a vlookup to lookup the...
  6. A

    Returning multiple Max results

    Hi wondering if anyone could help? I have a report on questionnaires I'm doing where I have to return the MAX and MIN values of the results. I first started using the =VLOOKUP(MAX(C4:C12),C4:D12,2,0) formula but it only returns the first MAX value to me but instead I want a formula that can...
  7. M

    Return salesperson with maximum sales per client

    Hi, thanks for reading this post! (1) I have a table with the data, like this: Client Salesperson Sales ($) Google Mike 1,000 Apple Jim 5,000 Apple George 4,000 Apple George 3,000 ... ... ... (2) On another sheet, I'm creating a report, like this: Client Frequent/Max...
  8. S

    Find more than one maximum value before a zero

    Hello everyone I'm trying to use the formula =MAX(FREQUENCY(IF(T2:T11>1,COLUMN(T2:T11)),IF(T2:T11>=1,COLUMN(T2:T11)))) to find more than one maximum value before a zero from a range. Column T has this values 1 2 0 1 2 3 4 5 6 0 I want a formula/formulas that will...
  9. A

    Get MAX value and Other Value based on Criteria

    I have a table (pasted below) showing COMPANY, BRAND, VALUE. I am trying to put a fomula in E2 that looks at the company name in E1, then looks in the table and picks the brand AND the value for ONLY the MAX for the company in E2. So, E2 should come up with BRAND3: 30 F2 should come up with...
  10. B

    How to show MAX in row that contain #N/A value

    Hi All, How to show MAX in row that contain #N/A value ? this is the formula =IF(C3=MAX($C$3:$C$9),C3," ") but the problem is if there are #N/A i can't show MAX. Any help is appreciated.
  11. R

    Calculate max sum of N values in a column

    Hi, I am trying to calculate the maximum sum of values within an hour in column. Because the number of values within an hour isn't constant (see my example below) I'm having a lot of trouble trying to get this to work. As you can see in the sheet below, the times are in column A and the value...
  12. A

    Excel - Max date by range from another workbook

    Hello, This is my first time posting in such a forum. I'm not very good with excel but I understand the basics. I've tried looking around the internet for a fitting formula to my problem and couldn't find something specific. I need a formula that will take 2 numbers from Workbook 1 Columns A &...
  13. R

    How to integrate VLOOKUP with MAX function?

    Hello everyone, Kindly let me know how to integrate the VLOOKUP function with MAX in order to format data of Table 1 for the given query ids as in Table 2. Moreover, I would appreciate it if you could help with the formula to populate the Max identity value in the neighboring cell: MS Office...
  14. B

    Need help recording max values an array changes going down a column

    I am sure something like this has been answered numerous times but I cannot seem to find something similar. Basically, I need excel to record the max value in Column A in Column B as it goes down Column A. I have attached an image showing what I need from a sample set by manually solving my...
  15. W

    Power Pivot - aggregate within groups to determine max value

    I'm looking for a formula (for Power Pivot) that aggregates within certain groups and across other groups to determine the maximum. Here's my data table: State Customer Fruit Qty NY A Apple 5 NY A Orange 1 NY A Pear 5 NY B Apple 1 NY B Orange 6 NY C Apple 2 NY C Orange 2 NY C...
  16. A

    Find days between two dates

    Dear All, I am looking for a simple formula, which will display the number of days in a year. Kindly help me. Name DOJ EOS 2013 2014 2015 Employee 1 01-01-13 08-08-15 364 364 220 Employee 2 05-04-14 31-05-16 270 364 Employee 3 15-02-14 16-04-15 319 106
  17. alm395

    Count Consecutive Text in Rows (MIN, MAX, AVG)

    I have a table with employees down column A and dates going across (3/20/20 - 4/4/21). Each date is tracked with that person's daily status. I already have a section that counts the totals of each status type, but am now looking to find the min, max, and avg of consecutive dates with the...
  18. Martin_H

    Find max value

    Hi everyone, I am trying to build a formula, but no luck. In the yellow cell (N5) I have a drop-down list of months that I can choose from. Currently, month "feb" is chosen. Now, I would like to get max value from the table below, from row coresponding to month "feb", so in this case from...
  19. Y

    How to find max value with empty cells & #div/0!

    Hello, I have inlcuded an example chart that I use regularly for work below (assuming it starts in cell A1 - so data range would be B2:AH34). Is there a way to find the max value of this chart, or even the top 5 max values (would be ideal but will settle for just one max figure for now if it's...
  20. R

    Find address of max value, sports stats

    Hi, I have a table of sport team, which shows, how many goals (with assissts) 2 players scored together (so if player 5 scored a goal and player 16 assisted on this goal they will have one common goal). There is an example of the table, players numbers are in the first column and row, common...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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