Get instant live expert help on I need help with excel maximum value

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a row of measurements and need to find the maximum variance. That is the lowest number divided by the largest number. How can i write this as a formula in excel? Example: 127 111 119 120 126 maximum variance .126 I always have 6 values in the roll and I need to calculate the maximum value for each row
Solved by T. U. in 21 mins
Can you create an if statement to return a number with a maximum value. Even if the percentage is over 100%
Solved by E. W. in 25 mins
i need help to find the maximum profit in regards to production using excel.
Solved by I. H. in 12 mins
I am trying to come up with a spreadsheet that will break a single number down into multiple cells. The results shown in the cells will have minimum value of zero along with the first cell having a maximum of 20, the second cell maximum of 5 and third cell with no maximum. I have come up with solutions for the first and third but not the second cell.
Solved by A. B. in 26 mins
I need help with either a vlookup/hlookup or index/match formula I have a table of values with the column headings as dates. In the column after the last value I need to insert the date of the column associated with the maximum value in that row. Example: Row 11 has dates in each column from J to U Row 30 has values (unsorted) in columns J to U I wish to insert in cell V30, the date from row 11 that corresponds to the MAXIMUM value in row 30 from columns J to U. So, if S30 was the maximum value the I wish to display the date from S11. Any ideas on how to do that?
Solved by V. Q. in 16 mins