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!”
Here are some problems that our users have asked and received explanations on
Looking to call the maximum from a large pool of data given a start and end date
Solved by D. H. in 24 mins
I want to find maximum and minimum calculator and to highlight maximum and minimum in each row
Solved by C. A. in 24 mins
Complete the Statistics Table, at the bottom of the sheet, by calculating the average,
standard deviation, median. How do you find the maximum or minimum value of a function (rows 103 – 107) for AS1, AS2,
AS3 and the Overall Average columns
Solved by M. E. in 30 mins
If the maximum number of any one fruit exceeds 10 pieces in an order, or the total order exceeds 20 pieces (all fruit),then mark it with "Special Order". Otherwise, mark it with "No".
Solved by K. H. in 22 mins
"You have previously purchased all the listed manufactured items/quatities at the unit cost listed for the ""Current Vendor"" (Column E). You are now allowed to purchase the items from any of the vendors (Columns E-G).
In cell K4 (""Maximum Total Savings"") enter the maximum possible savings when purchasing all the listed items/quantity. (The highest savings will come from a combination of all three vendors)"
Solved by C. Q. in 22 mins
Task 1:
Find "Glass" from column A, and lookup the most recent date for "Glass" from column B, and put it into the Cell F3. (10/8/2018)
Task 2:
Find "Glass" from column A, and lookup the maximum number for "Glass" from column C, and put it into the Cell G3. (1)
Solved by S. Q. in 25 mins
How do you set up and excel worksheet to pick out the max rows in excel in a list before the list is inputted. IE. I type out a list of numbers, it will pick out the largest without me "sorting" the data?
Solved by O. H. in 11 mins
I have a spreadsheet containing drill hole ID's (column A) with multiple samples, each sample with same ID (column B), as well as the depth at which samples were taken (column D). I need the maximum depth for each drill hole ID to create a total depth column for the drill holes.
Solved by T. B. in 12 mins
Good evening, I'm looking for help with Excel Solver and entering a constraint that will limit a total of 4 cells to a maximum number
Solved by G. Y. in 13 mins
How to run solver to calculate maximum product mix at 70 % of the current sales and at a 80% of the cost of cars sold?
Current sales is 4950 cars
Cost of cars sold-2,662,000
Solved by D. H. in 11 mins