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

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