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

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