Excel formula

Im using windows 10 and excel2010

I am trying to come up with a formula that finds the highest ascending number in a sequence, the numbers are across columns

e.g. 1,2,3,4,5,4,6,7,3  The answer I want is 5

e.g. 5,4,3,6,7,8,9,     The answer I want is 5

e.g. 1,2,3,4,5          The answer I want is 5

There are 30 columns in total if that makes a difference 

Thanks!  

By: brian lancaster

9 thoughts on “Excel formula

  1. ig

    Wow, superb weblog structure! How long have you been running a blog for?
    you make running a blog look easy. The whole glance of your web site is wonderful,
    let alone the content material!

Comments are closed.