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

how do i calculate the verage monthly costs in ranges i4:i20? how to find minimum and maximum values: minimum costs in j4:j20 maximum cost in k4:k20

Solved by M. J. in 16 mins

This problem was resolved in a previous session... but only in GoogleSheets. It did not work in Excel, because it exceeded the maximum number of nested formulas. I think my solution of simply needing a symbol to represent "ANY LETTER" is the best path, but I don't know how to represent this in a formula. Maybe I could assign a symbol the value of "Any letter"?? or does such a symbol already exist?? Please advise.

Solved by A. C. in 13 mins

Need to write an IF statement for a minimum function and a maximum function

Solved by S. E. in 19 mins

I have two weeks data in one column in one-minute increments. I want to find the max value every one minute (60 cells), put that value in a separate column and continue every 60 cells. Please help with excel max function!

Solved by G. H. in 25 mins

Row 1 is a unique identifier
Column 1 is a unique identifier
The data is recorded in cells B2:N12
Cells in Column O are the maximum values for that row.
For the attached spreadsheet I will describe what I want to happen for each row using row 2 as the example.
I want the formula in cell P2 to pick up the value in cell 02 and locate that maximum value in the data. In this case cell F2.
I then want the formula to go to row one and pick up the unique identifier in the same column as the identified maximum in this case F1 and put the value "36" in P2
Easy :-)
Thus the required answer for P3 is 50; P4 - 22; P5 - 21 et cetera
Regards struggling researcher

Solved by G. B. in 26 mins

how to average a column in excel? I need to find the average of column K sorted by column E and H

Solved by F. C. in 18 mins

Question on how to calculate median and maximum values from a large data set for different categories

Solved by K. B. in 11 mins

USING SOLVER TO MINIMIZE COST AND SUPPLY DEMAND FOR PRODUCT - Sheet ej2
You work for a company that operates in 5 cities and sells tomatoes. The tomatoes are distributed in bags and can be purchased from 5 different suppliers. A city can buy from more than one supplier and a supplier can sell to more than one city. Suppliers have a limit on maximum bags that they can sell. In turn, cities have a fixed demand for tomatoes that must be fully supplied.
The objective of this exercise is to choose how many bags to buy from each supplier in order to supply the demand for tomatoes in each city and minimize the cost of buying bags of tomatoes.

Solved by K. F. in 25 mins

please read full then only answer
i need to match maximum possible amount from 2 rows
where amount can be identical and repeat many times
I want to reconcile this and do not mark amounts if it remains unmatched
remember there are repeated amounts in same column

Solved by G. S. in 23 mins

Add Minimum Cost and Maximum Cost rows that are formatted similarly to row 50 (Average Cost row). Use functions to calculate the minimum and maximum costs for the systems purchased.
Convert the Initial Cost data including the Average Cost, Minimum Cost, and Maximum Cost, and the Depreciated Value data from a generic number to accounting format with no decimal places.
Copy the average, minimum, and maximum functions to the Depreciated Value columns.
Merge and center the title “Desktop & Laptop Systems Inventory & Depreciation” above all of the columns with data.
The CEO has asked you use conditional formatting to create an easy visual on the spreadsheet of any device that is near the end of its useful life. Utilize conditional formatting for all columns that contain a depreciated value of less than $500 they will appear red.
Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.

Solved by Z. A. in 24 mins