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!”
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