Results 1 to 10 of 10

Row number as result of LARGE formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-14-2017
    Location
    Poland
    MS-Off Ver
    2016
    Posts
    107

    Row number as result of LARGE formula

    Hi all,

    Is there an easy way to get cell reference or row/col number of large formula?
    I want as result row number, where LARGE formula found nth top value.

    LARGE(A1:A4,1) > result A4 or row-4
    LARGE(A1:A4,2) > result A2 or row-2
    LARGE(A1:A4,3) > result A3 or row-3

    A
    2
    4
    4
    5

    MATCH function not working properly with two or more same number (example 4), always return 2. Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 12-18-2015, 01:24 PM
  2. [SOLVED] Extending Formula to Cover Large Number of Rows
    By RossChip in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-14-2013, 05:54 AM
  3. [SOLVED] Drag down formula to skip a large number of rows
    By exclaymation in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-19-2013, 11:23 PM
  4. Repeat Formula on large number of cells
    By cyberuser in forum Excel General
    Replies: 2
    Last Post: 12-20-2010, 09:00 PM
  5. Large Form Help: Handling large number of text boxes and labels
    By laterdaysluke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2010, 03:12 PM
  6. [SOLVED] IF function based on True result with large formula.
    By naiveprogrammer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2005, 07:05 AM
  7. Conditional Formula to Give the Large Number
    By Gos-C in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2005, 05:18 PM

Tags for this Thread

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