First occurance in a column and MAX value above

[jcalow]

Need a bit of help. How can I find the first occurrence of a value in a column, and then find the MAX value of all cells above that value within the column?

I have found that its possible to return the row number of the first occurrence using the function:

=MATCH("VALUE",A:A,0)

However, I have been unable to find a way to feed this infomation back into another function.


Many thanks in advance,


Josh

[JohnTopley]

Try

=MAX(A1:INDEX(A:A,MATCH("Value",A:A,0)))

[jcalow]

Works perfect! Thank you so much!!

[JohnTopley]

Could you please mark thread as solved("Thread Tools" at top of first post).