maximum

I have values in 3000 cells in F column which I need to find maxiumum value at regular intervals. For ex, max(F4:F28) in G4 cell, max(F29:F99) in H4 cell, max(F100:F124) in G5, max(F125:F195) in H5 cell & continue. Basically I have to find the maximum value for 25 rows in G column & then next 71...

Hi, This is two questions in one, but they're linked: I want to record a time duration in MM:SS into a cell. I've set the format using "custom" and "MM:SS", but to get it to display properly I have to enter zero values for the hour, e.g. 00:10:32 to display 10:32. Is there a way to avoid...

Help with returning adjacent text cell for the maximum occurrence within groups of IDs Data: <tbody> ID (A) CODE (B) SKU Count (C) Code Occurrence (D) Code % Of Occurrence (E) Max Occurrence % (H) Results Needed 1 A 6 4 0.67 0.67 A 1 B 6 2 0.33 0.67 A 1 A 6 4 0.67...

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

Hello, I'm trying to find the maximum value of an array based on what fiscal quarter I am in. I have one cell that determines what quarter I am in, and I need a function that references that cell, and then uses the equivalent column in my data set to find the maximum value. Any ideas where to...

Hello, Good afternoon. I'm new in this forum, I normally solve my questions all by myself, cheking the internet. But in the last few days, i steped into a problam that i can't seem to get rid of, and it seem so simple, tryed some Vlookup, Match Function, but it doesn t seem to function the...

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

I understand why this happens and how to fix it by making sure there is ample space between pivottables, however I was thinking about a way to tell a user of a potential conflict. Is there something in VBA I could do (a maximumpivot range property or something) that I could run/make to see the...

Hello Excel Experts, I want to find the grade. first lookup the maximum no. from A column from first row, then lookup the column B value from the prescribed range. <tbody> Maximum 10 20 30 40 60 100 RANGE GRADE RANGE GRADE RANGE GRADE RANGE GRADE RANGE GRADE RANGE GRADE 09 10 A+ 18 20...

Hi All, I was asked to prepare an excel file that is able to calculate maximum proceeds from an auction of multiple assets. In short, company is liquidating all assets in a court process and we must track bidders for all assets. Some bidders will bid for entire assets while other bidders will...

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

I need to find the maximum value present in column AC against multiple instances of variable X in column D, and populate the value in column F. For example (apologies, I cannot share a true dataset due to the confidential nature of the data): <tbody> Column D ... Column F ... Column AC 1...

Good Day I have clients with unique number and client are purchasing with credit balance so we have registry including all purchasing transactions over all the whole month and it is registered on rows What I am seeking for is searching on the column related to transaction balance based on the...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

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 am trying to find a formula doing the following: I have three columns that I would like look for criteria to be met at each row, and then from a fourth column to enter the maximum value that represent the several findings. For instance, in the given screenshot, the first criterion is...

Please bear with me as I am definitely not an EXCEL or VBA guru, and I do not know if this has been previously described in the forum. I have a workbook where I am trying to compare 2 excel files to show that they are the same. The file is extracted from a database as a CSV to a secure...

I have a list with -.2, 0.5, 0.8, -0.9 I want a formula which can always take the maximum numerical value in this case -0.9?

Hello What is the max value I can enter in a cell. I tried =100^200 and I got #NUM message. I tried to google it but once I enter Maximum all results come related to Max() function! Thank you.

I need to find the maximum value present in column AC against multiple instances of variable X in column D, and populate the value in column F. For example (apologies, I cannot share a true dataset due to the confidential nature of the data): <tbody> Column D ... Column F ... Column AC 1...