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))
Bookmarks