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 maximum in each sequence.
That's what I don't manage. A sequence is defined between the "0" values of the colum A (you can see in my sheet an example with sequence 1).
3 Replies
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.
