maximum

I would like a formula that automatically figures out what the maximum of poynomial trendline will be no matter what numbers i plug in there. I've seen a few explanations but they are all way above my head. My X axis is A1:A4. Y axis B1:B4 X Axis Y Axis <colgroup><col...

I am getting the subscript out of range message for my VBA code within excel. Can anyone help me figure out where I went wrong in my code? Private Sub HW2_2() Dim FileNum As Integer Dim DataLine As String Dim col() As String Dim MyArray(1 To 50, 1 To 15) As Integer Dim i As Integer Dim j As...

Hi Guys , I have a table with three columns First contain date .. it take a form like (1/31/2018) Second contain time .. it take a form like (0:00:00) Third contain a variable speed that recorded for a mobile body Now , I kindly ask your help to find a way for extracting the maximum &...

I am stuck on a formula for creating a maximum adjusted value of (10) and (-10) for a Points system. The Controlling Body of a tournament issued a scoring criteria to all the score keepers for a Tie Game: Tiebreaker #1 - Cumulative Points Differential up to a Maximum of 10 plus or minus per...

I need to add an additional IF statement to a cell where I already have an IF statement. I need to add an additional IF statement to the below that states if A31="Destination Handling" then set a minimum limit value of 100 and a maximum limit value of 550 to P31, otherwise, use the below IF...

Hello all, Hope you are doing well today, I have a project which is incomplete without an excel tracker with the provided conditions below, will any one be able to help me with it? Assume the cell values as below information provided: · B9 = Receipt amount · I9 = Level of...

Hello, I have a below data in columns <tbody> ron 4 shawn 3 max 8 jack 2 rex 1 swan 12 </tbody> The next column I need a output showing the maximum. example - in the 1st row the maximum number is 8 but I need the ouput as max, same with the 2nd row, maximum is 12 and I need...

Hello, I am looking preparing a tool which helps in getting value based upon certain clauses provided below : If X= 500$ Y = 1 (Frequency for time period in months). Z=500$/2 and Z > 200$ then Z should be Maximum limit of "200$" per 1 month. In other case, If X=500$ Y= 2 Z= 500$/2 and Z>400$...

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

Greetings, I would like to identify a maximum value within a range of cells. I am currently trying the line below, but am not apply the correct syntax. What is the best structure to use for similar types of operations? Also, what rules surround the definition of the row and column...

Hi, I have the below table. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> <colgroup><col><col></colgroup><tbody> Name Number AA 1 AA 2 AA 3 AA 4 AA 5 BB 1 BB 2 BB 3 BB 4 BB 5 CC 1 CC 2 CC 3 CC 4 CC 5 </tbody> </tbody> I...

Hi All, Is it possible to have a formula compare the values in A1 and A2 and place the smaller value of the two in A3 with a Maximum value of 70? Thank you for your help

Hi, I have a table with ID numbers that repeat in some sections, in each of them, it will have a different K value. There is 3 possibilities, 0 indicates INPUT (IN), the maximum value is LATERAL OUTPUT (OUT L) and the middle one is DIRECT OUTPUT (OUT D). How can i do this?

Hi, I have a created a pivot table that shows the duration of run times. I am doing an average on the duration but want to remove the maximum value from the average as there are valid reasons for the run time to extremely longer than the remaining duration run times. How do I eliminate the max...

Hi. I would really appreciate some help with the below. Column A is the order number, B is the status of the indvidual line, C reflects B numerically with a "1" for complete and "0" for incomplete. If A1 = A2 then D is blank, if there is a difference then the completion % is displayed...

Hi MVPs and Gurus, I would like to ask a favor if you could direct me on the right path as I am a bit stuck. I'd like to write a macro to find maximum and minimum in specific columns of sheet1 and return the value to corresponding textboxes on a userform. For example I had a userform with a...

Hi guys I need to write a formula that will automatically reduce the retention claim amount. So at the moment retention is kept at 10% each claim until 5% of the Main Contract Price is reached. For example: The Main contract price $2,231,435.00 5% of this is $111,571.75 (this is the...

Greetings, I'm trying to import a record to a new table The record has 234 fields. I keep getting an error and only the first 130 fields are import. When I try to manually enter the missing records I get a maximum record length error. The record has a total of 3373 characters across all...

I have a column that contains asset numbers in the form of PDL-xxxx and PTF-xxxx. I need to display the maximum number for each prefix, or better yet the next available number for each prefix. More entries will be added and the cells need to update as that happens. I tried...

Using Excel 2000 Hi, Data are in cells C6:C57 I require count 5 & A but it possible to show only the maximum count in column D & E. Here is the example data Book1ABCDE123C1Show OnlyShow Only4C1Max CountMax Count5C1Of = 5Of =...