Forum Discussion
Formula assistance
Hello ! In my file, I have only two columns : -the column A with numbers -the column B with results I made by hand but it's what I want to be automatic. The thing I want is to detect the max...
In the file
add to D1 formula
=IF(A1=0,"",IF(A2=0,MAX(INDEX(A:A,LOOKUP(2,1/($A1:$A$2=0),ROW($A1:$A$2))):INDEX(A:A,ROW())),""))select column starting from this cell till end of the range and Ctrl+D
Thanks you to have answered me. The only problem is I think lookup function doesnt work with my version of excel because I have "#NAME?" in 3 cells (the one where I should have the maximum)
#NAME? could be, for example, if you use curve quotes instead "normal" ones and for quite many other reasons. It's hard to say what exactly doesn't work without the sample file.