I have a chart where I set lower and upper threshold lines by use of two spinners. It goes awry if you set the upper limit below the lower limit. Is there a way to set the minimum value of one spinner so that it can't go below the maximum value of the second one?
View 5 RepliesIs there any way (Through settings and/or VBA) to let the spinner function to increment by decimal value? The current setting allows the incremental value of 1.
View 2 Replies View RelatedI am setting up a couple of spinners to control dates. Unfortunately, the maximum value for a spinner is 30000 which is some date in 1986. I need the dates to go from current through 2010.
View 4 Replies View RelatedI need to detect all the spinner objects, and write on another worksheet the min and max properties...
View 4 Replies View RelatedI am having difficulty trying to find a walkthrough or any other information on how to pair a spinner box to a textbox. Preferably I would like it to show 12:00 and move in 15 minute increments and I seem to be hitting many roadblocks and errors.
View 1 Replies View RelatedI have a Piece of Code that copys a Row in my Spreadsheet and Pastes it underneath the original Row.
The Problem that I am having is that within the Row it Copys there is a Spinner in it. I want the Spinner to be copied also but the Cell that the Spinner is Linked to Says as the Original Cell, it doesnt move Down with the New Row Pasted in.
Here is the code that i have written to Copy the Row and Paste it down a Row.
Attached is a print screen. I'm struggling with using the min function in vba. I want it to find the minimum cumulative cost in week 0 out of the first three, and the copy the permutations of it (1,0 or 1, 1 , e.t.c.) to Week one column C & D of the model.
View 3 Replies View RelatedSituation:
I have two drop down lists 1) Country and 2) States/province
Country has list: [US, Canada]
If "US" is selected, [Arizona ,Florida, NewYork] is listed in the 2nd drop down list
If "Canada" is selected, [Alberta, Ontario, Quebec] is listed in the 2nd drop down list
Scenario:
First, I select "US" and choose the states to "Florida"
Next I change the country to "Canada" and forgot to choose province
Then, the 2nd dropdown list is changed to [Alberta, Ontario, Quebec],
BUT the current value is still "Florida"
Probem:
Now I have "Canada" and "Florida" selected in the sheet
Question:
If the primary list is changed, can I make the 2nd drop down list to show a default value (e.g. blank or the first entry i.e. Alberta)?
I want in A1 to find minimum SUM if no minimum number in row.
Here is example attached: ...
I have had a lot of luck finding what I need from the search areas, and I even found some information on the formula I am trying to build. The problem is I don't understand it and I need some help. First let me set it up for you. (I do not know the formula)
If cell L125 is has a value >0.00, I need to locate the smallest value the range of cells C125:F125, I then need to subtract L125 from that number, otherwise enter nothing.
This really has me baffled. I tried and I tried but it will not find the smallest value then subtract L125.
i'm trying to reference a cell value in the column to the left of a "min" value:
-A-------- B
1200------20
2400------15
2300------18
900-------22
i'm using the "min" function to select min value from column B (15) but only as a means to use the A column value (2400) in another formulahelpful
How can I find the lowest value in a range (say B5:H20),
and then sum its column ???
i.e. The minimum value in this range is in the cell F16... So, I need to sum range F5:F20 (only the column with the minimum value)
If Average GMV (Cell A1) is less than 75% of Average BP (Cell B1), use Average GMV, however the Average GMV or Average BP can't be less than $600 million. Multiply the result by .01*1/3. Below are two equations I've created, however each of them only solves one part of the problem.
=IF(A1<0.75*B1,A1*0.01*1/3,B1*0.01*1/3)
=IF(B1<600000000,(600000000)*0.01*1/3,B1*0.01*1/3)
Essentially Average BP would be used, unless Average BP was something like $900,000,000 and Average GMV was around $650,000,000. At this point Average GMV is 72% of Average BP and above the $600,000,000 minimum.
I have a table populated with equations. I need to write a function to find
the smallest value in that table. However, I want to ignore the zero values.
From a dataset containing 8, 5, 0, 7 I want to find 5, not zero.
I am looking to create a formula to determine the minimum value within the top 80% of a range, but relative to certain values in other columns.
e.g.
Column A Country
Column B New Customer
Column C Revenue
I need to determine what the minimum value is for the top 80% of revenue in column C, but only including Country=UK in column A and New Customer=Yes in column B. This will tell me that the top 80% generate at least £x in revenue
how can i do the following equation?
40$ if the sum is less than 1000$
75$ if the sum is less than 1001$ tO 3000$
100$ if the sum is greater than 3001$
C16 X C19 if sum is greater than 12000$
all should go in one cell
I am calculating several cells which in certian circumstances I want the amount to be limited to a max amount. I have a cell that will be used to indicate whether or not to limited the amount, but I am not able to come up with a viable formula. Here is my SUM Formula info:
My current calculation
=SUM(S16:S18,S21,E22:R22)
The cell that will drive the restricted amount
I7(H or S). If S is used in this cell the amount should be limited to 80. If H is used then the calculation should be exact.
I have a spread sheet that needs to compare numbers in a row & hightlight the lowest number in each row.
View 9 Replies View Relateddata in 3 colums (A2:c100)
Would like to sum the maximun values in each row together.
is Max(A2:C2) + Max(A3:C3) + Max(A4:C4) ........
I assume whatever works with max I can change to min.
I searched and found a couple things dealing with zeroes or other errors, but not the #N/A errors.
I have a range of numbers in A1:a100. To make this range linegraph-friendly, I have all blank or zero entries defaulted to appear as #N/A. Now the problem is that I would like to find the minimum number in the range, but the #N/A entries are messing things up.
has any of you happened to make a function that finds the minimum NONZERO value in a data range?
(i.e. all data are numbers, all of them are positive, but some of them are zero. The function should take the excel range as input, and return the minimum value above zero).
in a column let'e say A
I have the following values
Total
11
20
7
-10
30
-5
-25
16
3
21
-8
I whant to have a variable = the row number with the minimum positive value which is in this case row number 9 and the column value 3
If the result in cell i1 less than 1 to change it to 1
View 2 Replies View RelatedI want to find the minimum time value within a range of cells, excluding 0:00. Currently,
VB:
=MIN(BL5:CP5)
returns 0:00 if it exists in any of the cells.
I have numeric value in columns B, D, F, H.
I want to compare the values of these four cells in each row and update columns M (with the minimum value) and N (with the column of minimum value).
How can I manage this comparison?
I have created a worksheet with headers on each column each has different and used the =MIN function to find the lowest value. All good so far.... Now instead of returning the value I would like it to return the header text.
For Example.
Four columns Tom Paul Harry Bob
Tom has a value of 10 in the cell below.
Paul has a value of 5 in the cell below. and so on with Harry and Bob
Using the =MIN(A3:D3) I get the lowest value (in this case)5. I want to the returned value as Paul instead of 5.
I have 3 columns 1st one has numbers that reference a wellbore.
2nd have a depth
3rd has a number value (a mud weight) volume
Well API example Depth Weight
42050102600000 10000 10.2
42050102600000 9500 9.2
42050102600000 6500 8.5
42050105000000 12000 11.0
42050105000000 7500 6.0
42050105000000 10200 9.5
42050110100000 8000 8.0
42050110100000 9500 9.2
I want the formula to give me based on the well API number the max depth and the weight associated to that max depth. And the minimum depth and the weight associated to that minimum depth. I'm not sure how to say it in a formula. I don't want to use VBA.
Average in Cell J8 : J73
Handicap in Cell I8 : I73
What I’m trying to achieve is the Lowest Average Plus handicap – 1 = total
Example
Cell
J8 = 105
J9 = 169
J10 = 126
J11 = 155
Cell
I8 = 45
I9 = 35
I10 = 54
I11 = 21
Result 105 + 45 =150 – 1 = 149
Is there anyway I can do the below formula without it being an array formula?
View 2 Replies View RelatedI have columns of data as per below and if the data in Column A meets a certain condition I want it to return the minimum in Column B.
Column A Column B
BU1 5.45%
BU1 7.00%
BU2 10.00%
BU1 4.67%
BU2 3.50%
So, if Column A contains BU1 I want to know the minimum of the BU1 %'s.