Get instant live expert help on I need help with excel max value
“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
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
I have a problem regarding to How to Get Information Corresponding to Max Value in Excel
Solved by I. C. in 12 mins
need to plot neighbourhood for matrix in my excel sheet with nearest value max 1 min 0
Solved by G. Q. in 17 mins
Data in column A = AE0001 AE0002 AE0003 AE0004 AE1001 AE1002 AE1003 AE2001 AE2002 AE2003 AE3001 AE3002 AE3003 AE4001 AE4002 i want to type a formula that can return automatically look for data that starts with AE0 and return me the max value i.e. AE0004 and look for AE1 and return me tha max value i.e. AE1003 and look for AE2 and return me tha max value i.e. AE2003 and look for AE3 and return me tha max value i.e. AE3003 and look for AE4 and return me tha max value i.e. AE4002.
Solved by C. C. in 26 mins
Hi, Looking for a formula. I have a set of data and want to add in one cell that has the max value and have another cell display which Name that max value is associated with
Solved by O. E. in 28 mins