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

Need help tweaking a COUNTIF formula.. Max number of arguements

I cannot work the solver for excel I am trying to find the max amount of weight i can fit in a knapsack

Hi, I am trying to create a formula in excel that would do the following things: 1. Scan a column (B) and find out what times work was performed. (Eg- 2pm- 7pm) 2. Then run that hours against a range and see if the max hours worked fall within the specified range or outside of it. (Eg-Range 3pm-6pm) 3. If the hours are withing the range change he labor category accordingly to L1 or L4. See attached spreadsheet. Any help would be appreciated.

I need assistance regarding a formula to pull a specific phrase from a cell containing a sentence. I am using the following : =INDEX($AB$2:$AB$146;MAX(IF(ISERROR(SEARCH($AA$2:$AA$146;'[January 2018 C3D.xls]January 2018'!R7));-1;1)*(ROW($AB$2:$AB$146)))) however it is failing to pull the information through and seems to not exact match the values.

This is a portion of one of our employee's workout program. For the purposes of this test we will be focused how the values in cells B5-B7 are calulated. For the purposes of this test some concepts may be helpful but are not critical. An e1RM is an estimated 1 Rep Max, that means the maximal lift that can be accomplished for a specific exercise. Reps is repetitions, or the number of the exercises to be completed, and RPE is rate of percieved exertion, rated 6-10, 6 being the easiest, 10 being the hardest. You can roughly calculate the weight to use based upon your current e1RM and the E1RM sheet in this workbook.

is sorting data and filtering Data the same thing? also wmat does this mean? "turn on total row and set in various functions: SUM,COUNT,AVERAGE,MIN,MAX

Set up and solve using Excel Solver. Max: 3Xa + 5Xb + 3.5Xc+4.5Xd – 37Ya – 53Yb -45Yc-35Yd S.T. 5Xa + 8Xb <= 835 - 3Xc-3Xd 22Xa + 18Xb + 30Xc <= 1950 Xa >= 105-Xd Xa <= 9999Ya Xb <= 9999Yb Xc <= 9999Yc Xd<=9999Yd Xa, Xb, Xc, Xd >=0 Xa, Xb, Xc, Xd =Int (Integer variables) Ya, Yb, Yc, Yd = Bin (binary variables)

I need help creating a formula to look up the max value in of a column in a tab.

Hi - I'm looking for help writing a formula that finds the MAX value of two calculations and ignores errors if one of the calculations results in an error.

Hi, I have linked two tables in Excel Power Pivot with text values and want to collect an another text value from one of the tables. It does not work and I got the following translated message "An individual value for the test2 column in the WBS Explanation table can not be determined. This can happen when a metric formula refers to a column containing multiple values without specifying an aggregation like min, max, count or sum to get an individual result." If I collect a numeric value instead of text value it works. Please help with a solution.