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

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 from the same table instead of text value it works. Please help with a solution.

Hi, i m Rajiv and i using for excel find max date based on criteria with lookup formula as given below but it could not find text value it find only numeric value =LOOKUP(2,1/(MAX(('Booking VVIP'!$B$10:$B$2510=$A6)*'Booking VVIP'!$G$10:$G$2510)='Booking VVIP'!$G$10:$G$2510),'Booking VVIP'!$G$10:$G$2510)

I have a MAX(IF formula that isn't populating all the dates from the data source in to the primary sheet and I don't know why? I am using ctrl+shift+enter to put it in to an array format

Require assistance with a formula to calculate a payment based on a gate open % and gate close % (min and max).

Please review all tabs… and do an analysis that shows, for each group of customers that bought 2 items, what was the min, max and avg total $$ sales; repeat for each customer that bought 3 items, etc all the way until 10

I need a formula or function to calculate the average of a series of cells but filtering out the top(MAX) and bottom(MIN) cell quantities

I need to make values have a min and max, but show a value of zero until cells have been edited for that row

I want to create a formula for a cell that's max value is 15, where if one cell minus another cell equals as much as 15, the original cell shows that sum minus another cell.

how to show the player with the hight score in excel using MIN and MAX

I need you to solve the error in this formula I made. What is the right way to type this formula? Formula: =IF((AND(MAX(C2:C25),MAX(F2:F25)), "BONUS", " "))