maximum

I want the max value for red - suitable for excel 2000,thanks. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> red 15 blue 17 red 16 red 14 blue 12 blue 13 red 15 red 14 red 13 red 12...

Hello! I am trying to populate missing values based on historical data. The issue is that not every historical year contains data for every variable. So, what I need is a formula to pull the maximum (non-zero) value for a variable from the most recent year that contains data. Example...

Hi. I have a question regarding how to find the median, mode, maximum, minimum & maximum with multiple criteria. I understand that I have to use the if function, but I am not sure how to go about it. I attempted to find the median, but I got an error (#value!). Here is the formula that I...

Hi Little bit of a complicated one (for me) so i'll explain as best I can and would appreciate some help from the experts (you :)) I have create a measure that basically says if the cumulative total is less than or equal to whatever the percentage threshold is (this changes via a slicer), then...

I currently have the code below to find the maximum value in a column. After finding the maximum value I need to associate that number with another value in the same row but a different column. I want to find the maximum value in the range ("AX6:AX29"). I need to associate that number with a...

How would you go about finding the maximum value in a column using a for loop? I want to be able to store the maximum in a variable.

I have the following code to calculate the maximum value: Windows("Schedule.xlsx").Activate Sheets("RESOURCE").Select Range("AX6:AX32").Select Range("AX32").Activate ActiveCell.FormulaR1C1 = "=MAX(R[-26]C:R[-3]C)" Range("AX32").Select Max = Range("AX32").Value 'Max...

So I have to calculate the number of months between two dates. I have that formula (=DATEDIF(F3,$D$1,"m")+1). However, I need to put a caveat in there that says if the number is more than 11, keep it at 11. This number is being used to average a sum and the number of months to average is...

In Column A, I have team function, in Column H I have Status, in Column S, I have Weeks Active. I need to return the minimum and maximum values in S (not including 0) if A = "Chief Operating Office" AND H = "Active" Does anyone know how to get this going? I'm dying inside trying to figure it...

I want to find the maximum number of times a person accessed a system in any ten-day period. The data are a single row for each occasion that the person logged in, including a timestamp: Person Date Login xxx 2/1/17 10:03:01 yes xxx 2/1/17...

Example data below to explain a little further- Basically what I need to do is figure out a macro or a formula column which will calculate out the possible outcomes based on the data set that will find the consolidated versions possible. Maximum weight for this example is 20,000 Maximum...

Hi I'm a bit confused on this one... In Excel 2007, I am using a trendline on a "Line with Markers" chart. I have Date on the X-axis and Weight on the Y-axis. I'd like to do a 1-year projection from the last date where there's a Weight value plotted on the chart. For example, if I have...

I have a table of data, an extract of which looks like this: <colgroup><col span="2"><col><col></colgroup><tbody> Country Product Office Sales UK Shoes Leeds 100 UK Shoes Leeds 100 UK Shoes Leeds 150 UK Shoes London 200 UK Shoes London 340 UK Shoes London 560 UK Shoes...

Hello guys, I have found the answer of a bunch of my questions through communicating in this website and hope this time be the same. PROBLEM: take some parameters (i) each with a minimum and maximum capacity. I have an amount of entry which can be assigned to each parameter so that at least...

Hi guys, I have a machine that is spitting out torque data that I am transferring into excel. I decided to filter it so that I am not overwhelmed with data that I do not require (no torque / 0 values). The data is also converted into inch lbs from NM. New data is added to the top row of the...

It seems I’ve reached the limitations of Excel as it no longer works the way I require. Basically I have a single controlling spreadsheet which controls many other spreadsheets. As I manipulated numbers in the controlling spreadsheet it modifies all the other spreadsheets and I get the results...

I have several pivotcharts in a sheet and their pivot tables on a separate sheet. I am stumped on a code that will return the maximum and/or minimum value from the pivot chart. My charts have bars and scatter points but all I need is the largest value that exists in all the data the pivot...

Hi, I am using the following formula to get maximum value from a particular cell across 97 different sheets with name variation. This works fine. How can I get the sheet name from which the maximum value is coming? Best, Sushant =MAX(MAX('LK1 - 4.1 Stäbe - Schnittgrößen:LK9 - 4.1 Stäbe -...

Excel 2010 Right now, I am working on a table that is going to count the amount of each part purchased. Then, I want to have a cell that will check which cell is highest, and report a cell that is adjacent to the highest one. It sounds complicated, but the picture should make it make sense...

Hey there, guys! I'm struggling with a certain issue a bit. I need to calculate monthly bonuses in Excel in an automated way. Which basically means I need to answer the following question: "If we know minimum and maximum bonus amounts, starting target achievement, and step value, how much the...