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

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)

Solved by S. H. in 17 mins

im trying to get a formula to find the max/large In a set of cells and show what is in an ajoining cell
eg. find the max/large value and show who did it
name score
pete 7
sam 4
james 10
alan 2
result = james

Solved by I. Q. in 13 mins

I need a formula that returns values from min to max, from an array of 3 values. If there are repeats with those 3 values, it must return zero.
i.e. column 1 is always the minimum
column 2 is greater than column 1 or zero
Column 3 is greatest value or zero
there are not always 3 values in the array, in some cases value appear more than once in the array.

Solved by A. Y. in 23 mins

I'm trying to make a VBA function with two arrays; the first array has the numeric values while the second array has the names. The function will find the value in the first array that is the largest and return the corresponding name (from the second array).

Solved by D. Y. in 11 mins

In Open Off. Calc I need a formula that finds the max value in a row of cells and then divides that max value by 6, IF the max value is in column D, and divides by 4 IF that max value is in column E, and divides by 2.4 IF that max value is in column F, etc. I tried =if(max(d3:i3)=d3)/6 and that worked fine to give me the correct fraction as a result (0.167) when the max value in the row was in d3 with a value in d3 of 1.00, but when I tried it with a value of 2.00 in the next row (d4) I got the same result of 0.167 when it should be 0.333. Then, when I tried =if(max(d3;i3)=d3)/6, if(max(d3:i3)=e3)/4 I got an Error 509. (formulas in column M)

Solved by C. J. in 29 mins