maximum

Hi I need a formula to look up maximum date and corresponding state In below case it should look at state , eg VIC and also maximum date 04/01/2019, giving answer 50 <colgroup><col width="64" style="width: 48pt;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt...

Hey guys So i know that 255 is the maximum number of series that excel can plot. However would excel be able to plot more than 255 series on a graph but only having 7 or so displayed at one time? I am trying to make a dynamic chart that changes what series are plotted based on different...

Hi All, I've developed a spreadsheet which is an audit document however some sections are not applicable to some sites. My issue is that because the questions are not applicable, I don't assign a score which results in a percentage score of 0%. This has a negative impact on their overall score...

I have a table starting in A6. I have date and times in column A and numerical values in column B. I want the date and time of the maximum value in column B. To do this I have =INDIRECT(ADDRESS(MATCH(MAX($B$6:$B$36000),$B$6:$B$36000,0),1)) This gives me a date/time that is 5 rows out from the...

Hi everyone ! I come for your help on Pivot tables. So I have done a pivot table, which depicts the maximum of a value on a specific date, for several parameters. See image in this link: http://www.noelshack.com/2018-49-3-1543999976-capture.png So I have the Max values for X and Y on...

Hey! Unfortunatelly, I am still not good at defining own functions in power query. May someone of you can help me. I have the following table: Date - Value 01.01.2018 0.75 The aim is to get for weekdays a maximum value of 0.75. So if the value ist 0.76 and its...

I have a column with data: AB001 AB002 EF001 EF002 EF003 KE001 KE002 KE003 AB003 The formule which gives me the Maximum String in the Strings starting with EF (the result of my formula => EF003) is: ="EF"&TEXT(MAX((--(LEFT(A1:A9,2)="EF")*(RIGHT(A1:A9,3)))),"000") with Ctl+Shift+Enter NOT just...

Get Date From Column C Matching Row Of Max Value I have an Excel spreadsheet where I save history of currency exchange rates. In one cell I inserted the formula =MAX(A:A). This gets the maximum exchange rate appearing in that column. In another cell I inserted the formula...

Hi All So I am using the following formula to calculate payment entitlements: =IF(L145="Scheme A",P145*30,P145*60) So Scheme A pays £30 per day and Scheme B pays £60 a day (in the above if Column L contains "Scheme A" it multiplies P by 30, if L doesn't contain "Scheme A" then P by 60) . This...

I would like to return a demographics category's maximum (lowest) dimension in text form. I'm able to determine the maximum value of the dimension, but I can't figure out how to return its text. Please see sample below. The maximum dimension for the birth year demographics category is fairness...

generate all 7-letter formations, maximum 3 letters repeated. ex = aaabcde ... bbbcccd, etc. we have 10 letters = abcdefghij to conbine the formations with 7 letters please!

Hello all, I have a spreadsheet that has data running horizontally and at the bottom, the function =SUBTOTAL(104,L3:L65) to give me the maximum number in the column of data. This formula was then drug horizontally. I have since wanted to add cells to this, and have entered in the formula...

I have the following code to check the input of a Textbox. So, for say TextBox301, I call a routine to validate the number I enter. I have a lot of groups of TextBoxes and they all have different maximum integer values, so I pass the maximum value using public constant n: <code>Private Sub...

I am trying to get the highest number from a range of order no. that all start with 2 letters,Eg 'EC1189' etc. I can strip the number from a cell easily with Value(right(H6,4)) And can get the maximum from a small range with max(Value(right(H6,4)),Value(right(H7,4)),Value(right(H8,4)))...

Greetings, I have a bar graph with the y-axes expressed in percent. The minimum percent value is always 0%. However, the maximum percent value can exceed 100%. Sometimes, depending on the data, if I set the y-axes maximum scale for Auto, the chart may have a scale that is less than 100%. I...

I have data in column B like below. I want the data split into the next columns and each column must have a maximum of 70 characters. I don't want it cut off exactly at 70 as it may split a number within the cell. It will have to be at the last '/' before 70. There may be some cells that won't...

Hi, I need some help to get Excel to extract all the smallest numbers [RED] in a repeating data sequence that goes from maximum to mininum and back to maximum... <tbody> <tbody> <tbody> 11-Jan-03 162.63 12-Jan-03 151.60 13-Jan-03 140.43 14-Jan-03 129.08 15-Jan-03 117.48 16-Jan-03...

Hi, I have an excel table with 20000 lines. Here is a short sample it, with license plate number (column B) which last process phase they have gone through. There are some duplicate values in the plate numbers, which have been indicated in column C. In column D, I would like to return for each...

hi, i have a lot columns of numbers ( A all the way to BZ), and i need to write a macro to locate the cell with maximum value in each column. And i cant use "worksheet.function" as it greatly slows down my code. Wondering if anyone has any suggestions? I tried googling and all i found is using...

I want to find the x value which corresponds which half the maximum of the y value, and i want the x value to be greater than the x value which corresponds to the maximum y value So if you had a curve, and you looked at where the y corresponds to the x there would be 2 values. I want to find...