+ Reply to Thread
Results 1 to 17 of 17

Search highest numbers in a row

Hybrid View

  1. #1
    Registered User
    Join Date
    01-02-2015
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    9

    Re: Search highest numbers in a row

    I can't save my excel worksheet it there is failure in the formula.
    I slightly adjusted the formula into this:
    =IFERROR(INDEX(33:33(IF($B$33:$CLW$33>20;COLUMN($B$33:$CLW$33));ROWS($P35:$P38))),"")
    I changed the columns into semi-columns and changed $1:1 into $P35:$P38. When I commit this I get the notification that there aren't enough arguments for this formula.
    The workbook in which I tried it is still the same as the one I uploaded

    Grtz

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,412

    Re: Search highest numbers in a row

    I've put the formula in cell P35 of the file you attached to Post #5, and then copied it down.

    Hope this helps.

    Pete
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 12-23-2012, 08:53 PM
  2. Find top 2 lowest numbers and top 2 highest numbers
    By photographex in forum Excel General
    Replies: 7
    Last Post: 02-12-2011, 10:57 PM
  3. Search column for highest value, then second highest, etc.
    By MDPlanner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2010, 10:39 AM
  4. Replies: 6
    Last Post: 02-24-2010, 11:48 PM
  5. Replies: 1
    Last Post: 01-09-2006, 09:30 AM

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