Get instant live expert help on how to find max value in excel

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a problem regarding to How to Get Information Corresponding to Max Value in Excel
Solved by I. C. in 12 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
Hi, i m Rajiv and i using for find out max date value 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
How to find the p-value of this data in excel.
Solved by F. H. 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