Looking to check back three or possibly four cells in a column till it finds the larger

Originally Posted by FDibbins

did you try jis 1?

=if(B31>=B34,1,if(B31>=B33,1,if(B31>=B32,1,1)))

Hello again Fdibbins,

Yeah, but because of the = to involved in the formula it returns the value. I'm looking for greater than only and that returns if it's equal to also. I'm needing it to only check elsewhere if it is equal to the previous. If that makes sense.

I may have to do some hidden cells with it, but that's ok. As long as it works is all that matters.