Get instant live Excel expert help with MAX Function

“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

Hello,I have a historical time series going left to right. I have about 50 rows and 3,000 columns for each day. I have a column at the end that shows the max value in each row. I want every other value expressed as a percentage of this number. So I already have a blank row in between each populated row where I want these values. Not every space is populated, so I just want a percentage beneath each box that is populated. Can you please help me?
Solved by B. E. in 28 mins
need assistance with creating a formula in excel 7.5% per year with a 6 year max
Solved by Z. C. in 14 mins
Hey, I have this task I cant solve Its a survey that needs to count amount of "error" answers People in survey was asked to rate their classes 1-5 (Class A-F) And thereafter in last column they have to write letter of their favorite class. And if they chose letter than isnt MAX number of that row, then its an error:) And then I want to count it, and I want to do all this in 1 cell somehow
Solved by B. B. in 19 mins
I have an excel spreadsheet that calculates wage loss for clients. We calculate weekly wage loss as follows: total hours missed per week * hourly pay * 85% However, we have to max the total at $500.00 per week. How can I get Excel to choose the max of $500.00 if the wage loss calculated at 85% exceeds the $500.00 maximum?
Solved by G. F. in 27 mins
Can't work out how to select a name based on the max number
Solved by T. C. in 24 mins
I need a line chart that has all three tests (TSH, T3 AND T4) results on it based on the date it was taken. then I need individual charts for each test with min and max in excel on them.
Solved by K. H. in 20 mins
I need two things. 1. I need a line graph to chart the results based on each test (TSH, T3, T4) according to the date. So date on the y axis and value range on the x axis. Tests on one chart. Then. I need a chart for test TSH with the dates on y and value on x, and a line to show that... but I also need a MIN line and a MAX line. I need this for all three tests. So i need 4 seperate line charts.
Solved by D. S. in 16 mins
MAX function excel is not working as the result of an IF formula is not a number How do I use an IF formula to return a number so that max will work?
Solved by T. U. in 26 mins
I have a bar graph (the first graph with a minimum data value of 10 and a max value of 270. For this reason the bar with the small value appears very small. How do I change the y axis interval so that the value 10 can appear taller?
Solved by M. H. in 29 mins
help me to understand theFirm’sProfit Maximization Problem The firm’s maximization problem is given by max q,E,K pq−wE−rKs.t.f(E,K)≥q
Solved by M. S. in 16 mins