Results 1 to 12 of 12

how to find top 25 Values from more than 1000 rows with their corresponding names

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    6

    how to find top 25 Values from more than 1000 rows with their corresponding names

    Hi all,

    I needed help to find top 25 Values from more than 1000 rows with their corresponding names in a new sheet. I have a formula which works fine in a small data set but its not working with large data. the below is the formula which i got from a website and unfortunately i missed that link. I have a file also which i did a rough work. Maybe i need to change 10^5 value in the formula. can you please tell me what the meaning of 10^5 in this formula Any advice is greatly appreciated. Also can you please suggest how to use ISError function in this formula so that whenever #N/A ,#NUM! or something like this comes the cell shows as blank cell.

    =INDEX($B$1:$B$20,MATCH(LARGE(INDEX($C$1:$C$20+(ROWS($C$1:$C$20)-ROW($C$1:$C$20))/10^5,0),ROWS($1:1)),INDEX($C$1:$C$20+(ROWS($C$1:$C$20)-ROW($C$1:$C$20))/10^5,0),0))

    and to get corresponding amount :=LARGE($C$2:$C$21,ROWS($2:4))
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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