# 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!”

## 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

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 T. S. in 15 mins
I need to Apply multiple Validations in a column. 1) Restrict the maximum permissible length of the cells. 2) Restrict few Special Characters How can I achieve this?
Solved by F. F. in 26 mins
For salary ranges: I have the mid and I think I know how to calculate the minimum and maximum. What I don't know how to do is calculate the percentiles, i.e. 25th percentile etc. I looked at the excel examples on line, but I couldn't get them to work.
Solved by G. B. in 20 mins
I need help for one column I have numbers and add always new numbers in again the computer should tell me as soon there are 3 times the same number shows up and only maximum there are 5 numbers show up 2times then if this happen always counting from the last number I added tell me how many counts i have to go upwards to get my start point, and how to find the maximum value of a function in cell A8
Solved by X. F. in 26 mins
counting numbers in one column always count from the last number wait until we have a match a match is maximum 5 numbers with 2 reps and 3 numbers with minima 3reps
Solved by F. W. in 30 mins
I need a formula to multiply 1 cell by 520 and the maximum the product can be is 6000.
Solved by B. U. in 12 mins
I need the formula for: Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is \$500.00; therefore, employees with more than four dependents will receive no additional deductions.
Solved by D. F. in 20 mins
I'm using data validation to create a dropdown in excel, but there seems to be a maximum number of characters I can use? Any way around that?
Solved by C. J. in 21 mins
Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is \$500.00; therefore, employees with more than four dependents will receive no additional deductions
Solved by I. C. in 27 mins
I need help in doing my assignment with search function excel VBA solver (search for maximum profit)
Solved by V. Y. in 11 mins