max

Hello my dear friends, 1st post here.. I have a spreadsheet with several sheets where sheet name is the person's name (1st and last name). I need create a new sheet with consolidated data, where column A already have the person's name, and I need the MAX cell value from columns A-C at each...

Hello, I have a list of numbers, the list is not in order nor does the list always start with the same starting point. My need is to find the next logical number in the list (I've tried vlookup/max/index etc). The closest I got was a combination of max + 1 combined with vlookup. However, this...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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