+ Reply to Thread
Results 1 to 9 of 9

Find highest number before numbers start descending

  1. #1
    Registered User
    Join Date
    05-10-2019
    Location
    New Zealand
    MS-Off Ver
    2016
    Posts
    3

    Angry 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
    Last edited by 6StringJazzer; 05-10-2019 at 08:04 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    47,059

    Re: Find highest number before numbers start descending

    Hi, welcome to the forum

    Please Login or Register  to view this content.
    why not 9?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,386

    Re: Find highest number before numbers start descending

    Quote Originally Posted by FDibbins View Post
    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. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    3,580

    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. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    47,059

    Re: Find highest number before numbers start descending

    Quote Originally Posted by 6StringJazzer View Post
    Because after 5, the next number goes down.
    But OP asked
    Please Login or Register  to view this content.

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,386

    Re: Find highest number before numbers start descending

    Quote Originally Posted by FDibbins View Post
    But OP asked
    Please Login or Register  to view this content.
    True. I think we have an issue with rigor in the problem statement.

  7. #7
    Registered User
    Join Date
    05-10-2019
    Location
    New Zealand
    MS-Off Ver
    2016
    Posts
    3

    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. #8
    Registered User
    Join Date
    05-10-2019
    Location
    New Zealand
    MS-Off Ver
    2016
    Posts
    3

    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. #9
    Forum Moderator
    Join Date
    05-14-2009
    Location
    RDC
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    6,903

    Re: Find highest number before numbers start descending

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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