Get instant live Excel expert help to learn how to find max and min in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi I need to create a tool that will allow me to look at price per serving numbers (maximum, average, minimum) based on cuisine type and dish category. For instance, I need to select a cuisine type (e.g. Mexican) and a dish category (e.g. Entree) and get the maximum price per serving, average price per serving and minimum price per serving for the data set provided. Is there anyway someone can help me do this?
Solved by A. F. in 19 mins
What is the maximum number of trips completed in a 6-hour period throughout the 2 weeks?
Solved by C. L. in 12 mins
I need to make a chart to identify key products that drive maximum revenue
Solved by X. J. in 21 mins
I am currently handling a large scale data (ranging in some thousands in rows and as many in columns) I am trying to find a steepest point two ends of the steepest slope of the CURVE the two variables say column1 and column2 variables can have.
I am not looking for local maximum. I am looking for a global maximum.
Please help?
Solved by A. B. in 29 mins
I'm trying to solve various outcomes for a football match to show the optimum amount that could be wagered across 16 different outcomes, to maximise return (as a percentage of the total wagered amount). The attachment shows the simple formula I've been using but at the moment I have to manually change the amounts in Column D. Is there a way Excel can simultaneously change the values in Column D to reach either the maximum percentage return shown in Column G or to hit a target return rate?
Solved by X. J. in 17 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 to know the formula to use to find the lowest,average , maxima and minima to find the cost. referancing Column G.
Solved by A. Q. in 23 mins
A supermarket XYZ is determined to please its customers with a customer advantage card. Currently 30% of all shoppers are loyal to XYZ. A loyal customer shops at XYZ 80% of the time. An unloyal customer shops at XYZ 10% of the time. A typical customer spends $150 each week and the profit margin at XYZ is 7.5%.
The expected increase of loyal customers is 8% and the percentage of time a loyal customer shops at XYZ is expected to increase by 9%. What is the maximum cost of the advantage card per dollar in order for the program to be profitable?
Solved by O. J. in 26 mins
A supermarket XYZ is determined to please its customers with a customer advantage card. Currently 30% of all shoppers are loyal to XYZ. A loyal customer shops at XYZ 80% of the time. An unloyal customer shops at XYZ 10% of the time. A typical customer spends $150 each week and the profit margin at XYZ is 7.5%.
The expected increase of loyal customers is 8% and the percentage of time a loyal customer shops at XYZ is expected to increase by 9%. What is the maximum cost of the advantage card per dollar in order for the program to be profitable?
Solved by B. C. in 20 mins
A supermarket XYZ is determined to please its customers with a customer advantage card. Currently 30% of all shoppers are loyal to XYZ. A loyal customer shops at XYZ 80% of the time. An unloyal customer shops at XYZ 10% of the time. A typical customer spends $150 each week and the profit margin at XYZ is 7.5%. The expected increase of loyal customers is 8% and the percentage of time a loyal customer shops at XYZ is expected to increase by 9%. What is the maximum cost of the advantage card per dollar in order for the program to be profitable
Solved by C. S. in 28 mins