# minimum

1. ### Retrieving multiple Minimum Values

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...
2. ### Finding the minimum of a subset

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...
3. ### Get a row number from function

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 =...
4. ### min or max in a matrix

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!
5. ### MINimum Function and blank/empty cells

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...
6. ### Min between 2 dates

How can I get the minimum value between 2 dates? Thank you MM
7. ### How to Adjust the Axes to Accurately Show Data [Box Plot]

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...
8. ### Conditional formatting the minimum amount excluding blanks

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
9. ### Find minimum value in cells based on another cell

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...
10. ### Return All Row Numbers Of Minimum Value

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...
11. ### Adding increments over minimum number

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...
12. ### Apportioning values but keep in minimum value in formula

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...
13. ### Minimum amount of time in a column

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...
14. ### Method or VBA to get min reading for gridded data

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...
15. ### Help with looping a Macro

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...
16. ### Accessing the cell address used in a function.

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...
17. ### If statement problem - #div/0!

<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...
18. ### Dividing a range into 4 equal parts

I have a range of salary where I have a minimum (\$39,500) and a maximum (\$65,750) value. I would like to divide that range into four equal parts, where each quartile would have its own minimum and maximum value. The challenge I have is that I am basing my minimum and maximum value off of a...
19. ### Calculating variable costs for minimum 10% margin but also always a minimum value

4 years ago with the help of these forums, we managed to get a formula for us which we've been using ever since in our profit calculation sheet for e-commerce. It was this thread here...
20. ### Find Minimum Value in an Array depending on string in adjacent cell

Hi I need to find the minimum value in an array depending on a certain string being present (even in part) in the adjacent cell. So, in the example below, I'd like to return the MINIMUM value from cells B2:B6 only if any cell in column A contains a "2". In this example rows 2 and rows 6 are...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...