minimum

hi, i have an array of random numbers and i need to find the minimum number between the first highest number and the new highest number that will come later on. for example 1,2,10,7,5,3,9,2,11 - 10 is the highest, than 11 is the new max so i need to find the min between - 2. that calculation...

I have a work/marksheet where column BJ is the possible mark and Column BK is the actual mark. Column BL is the the percentage with column BM has a code for example C1. I have 7 sections in total. I have done the formula to pick out the Maximum and minimum percentage marks. I wan to output the...

I need help with what should be easy formula but I can't get it right. I have the following figures: <tbody> 2 2 0 0 10 0 0 </tbody> The average is 2, but I have a separate Formula which is a minimum of 2.5. How do I replace the zero values with whichever is higher of the average or the...

Consider the table below <tbody> COL1 COL2 COL3 COL4 EXPECTED RESULT ROW1 100 200 100 300 COL1, COL3 ROW2 200 100 50 400 COL3 ROW3 100 100 100 100 COL1,COL2,COL3,COL4 ROW4 900 900 900 900 COL1,COL2,COL3,COL4 </tbody> as an example i have added just four rows...

Hi, this seems simple but I just can’t get it to work. I’ve got two columns of data, and what I’m after is the third column. I need a formula I can roll down that will set out the minimum of each group in the third column – I suspect an array would work? <tbody> Group Value Min...

Hi, I am using a worksheet function to get the minimum value in a column as below. There may be 1-n rows it is looking at. Is it possible to find which row that the minimum is found, as I would like to check the value in Column C of the same row? Worksheets("Sheet1").Range("D6").Value =...

Hello, In vba, is there a way to use "application.worksheetfunction.min()" to find the minimum of a vector Inside a matrix. Exemple Data(1 to 3, 1 to 20) as variant Inside my Data(1,: ) i have dates. I would like to easily find the minimum date. Thank you!

I have seen references here to formulas like this =MIN(IF(A1:A3="",0,A1:A3)) What I'm doing is this =MIN(G2,I2) I want the minimum value (earliest date/time) from one cell or the other which are in date/time (mm/dd/yyyy hh:mm) format. The only issue is, it represents 2 blank cells as...

How can I get the minimum value between 2 dates? Thank you MM

Hello, So, I am trying to create a box plot of a statistical breakdown. My statistical breakdown does have negative values and I was able to make a box plot to account for the negative values by using a first and secondary axis. Right now, my problem is that I am not sure how to adjust the box...

Hi all, I have been trying various formulas without success. I need to conditional format a range of cells, say A1 to G1 to highlight the minimum amount excluding any blanks in that range. I just can't do it and it's doing my head in! Any help is greatly appreciated. Fo

I want to find the smallest number in column B on sheet 2 for each number on sheet 1 and put it in column H on sheet 1. Sheet 1 has unique whole numbers starting in C20 and below as far as C63. Sheet1: C20 1 C21 2 C22 3 etc Sheet 2 has the same numbers starting in A2 (A3, A4 etc) but...

Hi all I was hoping someone could help me with the following Excel problem. I have list of numbers in A and I want to find the row number of the Min value in that column, if the minimum value occurs more than once I need all the row numbers of the minimum value. For example:- Row 1 15 Row...

Hi I need help with formula So I have a spreadsheet, example A1 heading- Minimum number of tasks A2 '5' B1 heading- Actual completed B2 '6' C1 heading- Total incl over achievement C2 6.5 I want a formula which adds 0.5 for every 1 added over the minimum (but the minimum may change in the...

Hi all, This might be as much a maths question as an excel question. I’m trying to apportion a value between twenty different descriptors. This is linearly apportioned based on another numeric feature and will add up to the original value, example below. However, to make things...

I am working on aspreadsheet for paint thickness and the amount of time it takes to apply eachcoating. I am able to obtain the maximum, average, and minimum paintthickness. Using the same formulas, Ican only obtain the maximum and average – the minimum formula does notaccurately report the...

Hi, I have spreadsheets that have multiple readings in. The data can be 500 readings across (columns) by 500 down (rows). Basically a large square of thickness readings. Sometimes it can be even larger. I want to be able to get a minimum reading quickly from say every 25x25 grid of data and...

Hi, I am trying to calculate the 3D distance between the cells in range A1:V3579 and those in X1:AS4860. For each row in the first range, calculate the distance between that and all points in the second range, I find the minimum of all the data in AT and copy that row in the range to a...

I've been looking for an answer to this, but I guess I don't know how to word my problem in the best way since I haven't been very successful. I have a cell that uses the MIN function to find the minimum value between two different cells. In another cell, I want to use the value from the...

<colgroup><col width="91" style="width: 68pt;"><col width="99" style="width: 74pt;"><col width="89" style="width: 67pt;"><col width="99" style="width: 74pt;"><col width="123" style="width: 92pt;"><col width="97" style="width: 73pt;"></colgroup><tbody> Cubic feet Filing or Scheduling & CC Fees...