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

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