Get instant live Excel expert help to learn how to find max and min in Excel?

"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)"

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)

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?

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.

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

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

I have the following formula in cell BT27: =VLOOKUP(BV27,'Rates NEW'!F:H,3,FALSE)+VLOOKUP(BO27,'[Timesheet Input DO NOT MOVE OR RENAME WORKING TEST.xlsm]Pay Elements'!$B:$H,7,FALSE) The result in this example in cell CR4 is 35 But I want it to also look at cell BD4 and if cell BD4 contains “CS” I want the maximum value in cell CR4 to be 30. How do I do this please?

There are 50 part numbers that we are tracking usage for. For the past 60days, we have recorded the number of times each part has been used. We now want to determine how much inventory we should hold of each part to ensure availability. To make this determination, we need to know the number of times a particular part may be used in the time it takes to order and replenish (Lead Time). For the 50 Part Numbers listed in the attached file, find the Maximum Consumption over the course of the specified part lead time for a 60day period.

how to find the max of a function? I need a formula that will have a maximum limit of 8 in the first column and carry any excess to the second column.

Hello, I have an employee attendance tracker sheet which is protected by maximum nos 10, I want to be add more employees on it, like 100 or more, is there any way? it is VBA protected. I cannot upload this file because it macro enabled.