# Find highest number before numbers start descending

1. ## Find highest number before numbers start descending

Im using windows 10 and excel 2016

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!

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. Formula help doesn't tell us about your problem. I have updated it for you this time because you are a new member. --6StringJazzer

2. ## Re: Find highest number before numbers start descending

Hi, welcome to the forum

``Please Login or Register  to view this content.``
why not 9?

3. ## Re: Find highest number before numbers start descending

Originally Posted by FDibbins
Hi, welcome to the forum

``Please Login or Register  to view this content.``
why not 9?
Because after 5, the next number goes down.

4. ## Re: Find highest number before numbers start descending

Like this?

=IFERROR(INDEX(A1:J1,MATCH(TRUE,INDEX(B1:J1<A1:I1,0),0)),J1)

5. ## Re: Find highest number before numbers start descending

Originally Posted by 6StringJazzer
Because after 5, the next number goes down.
``Please Login or Register  to view this content.``

6. ## Re: Find highest number before numbers start descending

Originally Posted by FDibbins
``Please Login or Register  to view this content.``
True. I think we have an issue with rigor in the problem statement.

7. ## Re: Find highest number before numbers start descending

Hi Phuocam
Works a treat, would never have come up with this in a million years
Thankyou
regards
brian

8. ## Re: Find highest number before numbers start descending

Thank you for re-wording my question
Ill try to do better in the future
Cheers
Brian

9. ## Re: Find highest number before numbers start descending

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1