1. E

    max of

    Hi, I'm new to this forum. I have an excel sheet with over 2000 rows. I want to have the maximum number of the Quantity of each item Code when the location is the same. For example, you can see in the excel sheet i have the ItemCode : 389-12-040 1107 01 4.00 1 1107010 A 389-12-040 1107...
  2. M

    Find Max value

    Hi, I'm trying to find a formula that works with older versions of excel (not MAXIFS) to look up the client name in G3 the current month in H2 and give me the highest value in H3 for john in January 2019. I can make this work with a MAXIFS...
  3. V


    ABCDEFGHIJ10123456210.5300300300300450600750900300.252000501001502002503004011000100200300400500600510.25600600600600600600750900610.3100100100100100120150180710001150130016001920240028808901300101112123134145D2:J6D2=SUM(MAX($A2, ($B2*D$1))*$C2)D7:J7D7=SUM(D2:D6)B9B9=SUM(MAX($A$2:$A$6...
  4. K

    Using Vlookup or Index/Match based on a Max value

    I have a data set that has a list of interactions, including organization name, status of interaction, date of the interaction and score of the interaction. I am hoping to write a lookup that can find the score, for the most recent, completed interaction with each organization. Example of what...
  5. R

    Extracting PARTIAL words from cell

    I'm in a worksheet and trying to extract the words after the 3rd and 4th hyphens when they're available in column A (see table below for representation). <tbody> Digital - workbook - sheet Digital - workbook - app Digital - workbook - test Digital - workbook - sheet - max - version1...
  6. F

    How do I get Excel to return a value based on the max value in a table?

    0 1 2 3 4 5 1 1 2 3 4 5 3 6 7 8 9 0 5 1 2 3 4 6 7 2 3 3 4 2 I have a table as such with rows and columns in bold. I know the max value within this table is 9. How can I get Excel to return "3" and "4"?
  7. D

    Min and Max in sequence

    Good day, I have two columns of data, 1st is time and the second are values, The time column is from 4.00am to 4.00am the next day increasing by 1hour intervals, the values increase to a max and then decline in a series of highs and lows. I want to calculate the change in value meaning the...
  8. K

    Find Max in changing data

    In a excel sheet I have in column A a list of items, in column B a list of corresponding values. These values are updated daily over the course of a year. In column C I would like a list of the max value listed in column B over the course of time. I have tried putting the current MAX value...
  9. J

    Max unless blank

    I would like to calculate the Maximum date resolved from a column of resolved dates, unless there are blanks in the resolved dates column. If there are blank cells in the column, I would like the result to come back as blank. The intent is to highlight whether there are outstanding service...
  10. E

    MIN MAX AND AVERAGE - Excluding Zero value

    Hi, Wondering if anyone can help please. I need to find the min, average and max values from a column in excel. However, I need to exclude any "0" values, and to save be changing the range I need to also find the average based on a set criteria. So, like an average value in one column, but...
  11. G

    Finding Multiple Shapes

    I can't find the 2nd or 3rd Shape I'm want to edit. It locates the 1st one, but not the 2nd or 3rd. I used "record macro" to select the shapes and get the name. Sub PleaseFind() ActiveSheet.Shapes("Rectangle 9").Select ActiveSheet.Shapes("Rectangle 5").Select ActiveSheet.Shapes("Rectangle...
  12. O

    Need help - cant figure out the right formula

    Hi, I'm having Excel issues and I'm stranded after multiple hours of googling. Question: How can I perform a VLOOKUP when the value is included in several rows (I want the highest number) Context: I have one overview where I wish list to various type of Information. This information have...
  13. J

    textbox max of 2 and min of 1

    is it possible to input 1 and 2 only in textbox ?
  14. A

    Find the text from a range of cells on the same row.

    Greetings esteemed and learned people of Excel. Please help me with a problem that I thought I could easily handle, by using the max formula. I need to find the Height, Width and Depth of a series of cabinets. Each row caters for one cabinet, resulting in only one of the cells to have a value...
  15. C

    Power BI Return Max Date

    I have rummaged through posts but cannot get any formulas to work I have a project table that has Project ID's (only one occurrence of each ID) then I have a schedule table that has the same project id's but multiple occurrences for each task that a project has. Each task has what is called a...
  16. willow1985

    Combining 3 formulas (determine wk # max date, wk# min date, combine results)

    Is there a way to combine these 3 formulas? =MAX(DATE(T2,1,1),DATE(T2,1,1)-WEEKDAY(DATE(T2,1,1),2)+(S2-1)*7+1) =MIN(DATE(T2+1,1,0),DATE(T2,1,1)-WEEKDAY(DATE(T2,1,1),2)+(S2*7)) =CONCATENATE(TEXT(U2,"[$-409]D-MMM;@")," to ",(TEXT(V2,"[$-409]d-mmm;@"))) (T2 is the year and S2 is the week number)...
  17. D

    Min and Max Calculated on Other Cells

    Hi, I am trying to calculate the minimum and maximum amount the value of a cell based on another cell and cannot figure it out. I have never used this function. Helpful (hopefully) example. the max allowable increase is 10% but the below increase is 15%, so I would want the result to max...
  18. S

    Search and return lowest value (sounds easy but it's trickier than it sounds)

    Hi all, Below is a sample of Scottish education attainment data. the data is generated by other software and I can't control the output. I just have to try and find formula that will work with the data I get given. <tbody> Forename Surname (A) Subject Level (B) Subject Level (C) Subject Level...
  19. L

    How can I return the most recent account balance from a chart of multiple accounts

    Hi everyone, I thought this issue would be simple but it's actually proving to be quite difficult. I need to write a formula that will return the last balance for an account within a table of multiple accounts. Essentially the formula needs to look at the MAX date for all transactions...
  20. S

    Score Dashboard in Excel

    Hi All, I am working on dashboard in which target based scores are being given. e.g Min & Max target for Calling - Minimum 60 call and Max >=70 calls per day Minimum score 0 and Maximum is 20%, Score will be proportionate where Achievement 61= Score will be 2% , Achv 62= Score 4% and so on...

Some videos you may like

This Week's Hot Topics