minimum

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

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

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

I use the below code to automatically adjust my axis on all my charts to the maximum and minimum on the chart when c2 changes and it works great but it only works on the primary axis. Is there any way to change it so it works on both the primary and secondary axis. Thanks Sub...

Hi Everyone, I wascurious if there is a way to have VBA scale a logarithmic scale to the next base10. For example, I have written a series of code that generates numerous plots, each with varyingmaximum y values based on data within a column range. Iwould like to find a way for the code...

How do you calculate the minimum value of a measure not including blanks in power pivot? The example clarifies the question: https://www.dropbox.com/s/ayvk170koolx73s/Min%20of%20measure.png?dl=0

Hello All, I have the below formula which works if the lookup value is BETWEEN a minimum and maximum value but doesn't work if the value is EQUAL TO a minimum value. {=IFERROR(INDEX(Goals!$A$12:$A$16,MATCH(1,(E9<=Goals!$D$12:$D$16)*(E9>=Goals!$C$12:$C$16),0)),"")} Goals!$A$12:$A$16 -...

Hello Experts, I need you help to calculate max and min values Based on Designations. Any suggestion please. Thanks, Kamran Noor <colgroup><col><col><col></colgroup><tbody> NAME DESIGNATION PAYROLL SAIRA MALIK ASSISTANT 19,180 FAIZA ALI ASSISTANT 19,970 MUHAMMAD IMTIAZ...

Hello, I currently have a userform which is shown after a selection on another userform. This userform requires you to type in a number which I have set a maximum length to 8 characters. I am now looking for a way to modify this to have a minimum of 8 characters too. I would like for it that...

We have a take home exam at work and I badly need help. This is for my application as an apprentice for a new post. I need to create exactly 24 schedule patterns for a 24/7 operations with 24 employees. There are certain rules that I need to follow: 1. I need to have a minimum of 6 employees...

Hi, On Worksheet 1 I have 2 different graphs for which I would like the minimum and maximum scale to be dynamic. This goes for both the X and the Y axis. The minimum and maximum scale that I would like to use are calculated in cells on Worksheet 2. Could anyone help me out on this one? Thanks...

Hi, Please can someone help me? I have this code and it works fine if I just want it to look at column B to see if it has a minimum of 7 characters anything less except 0 and it calls for a macro called ColumnB. 'Update Only if Column 'B' is 7 or more characters.'Try and add Column C into the...

Got the easiest spreadsheet and really frustrated to why my Lookup function won't work or Index/Match combination. Key column are A and K - want to find minimum value in column K and the corresponding value in column A - Table array from A9 to K10000 - Make separate cell for Minimum value...

We have a file of order history for supplies. Within a storeroom I would like to find the minimum order time for each item within a selected time period. We run 2-bin Kanban so two orders on the same day would indicate a stockout. Primary key is Storeroom_Item#_Unit of Measure e.g...

This is the List of numbers 5 4 1 2 3 Now the formula cell d1 =min(A1:A5) Returns to the value 1, Now what i want to achieve is, the Cell d1 should return the value one cell above the Min value in the list, i.e it should give the value of 4 and not 1, thanks (Indirectly the cell should return...

Guys, Is it possible to use a formula e.g cell C7 '=(C4*C5)/3' but have cell with the answer remain no lower than a minimum amount? This is to calculate work hours based on a job size, however, if I input (C4) as a 1 (1 Tonne), I get an answer of 0 in cell C7. Not sure if I should be using...

I'm trying to figure out this formula: minimum value in the range which is less than zero than to display a result if Need to order parts or Not. so far this is what i have: {=MIN(IF(AND(04>0,04<0),"OK","Not enough parts"))}. But i get an error message a value used in the formula is of...

Tired myself but not that good a vba. Would like to set the minimum and maximum value of the xaxis with the min & max value in a range name. i.e. Chart 4 Xaxis minimum value = the minimum value of a range named dbyear. Chart 4 Xaxis maximum value = the maximum value of range named dbyear...

I have a few sheets I'm working with and I'm having a hard time adapting an index/match formula to meet my needs. On Sheet 1 is a table with a number of different numbers in the header with a number of other values in the rows below. On Sheet 2, there is a vertical row corresponding to the...

Hi, I have a textbox1 within a userform that I would like to limit to a minimum of 18 characters. If the textbox1 has less than 18 then I would like a message box to say so. Any help would be much appreciated. Kind Regards Dan