Register now or log in to join your professional community.
FRIST GET THE SEARCH KEY CLOUMN TOP TEN LIST BY THIS FURMULA : =LARGE('sheet2'!$A$1:$A$55,1) and repeat it down up to TEN now you have the bigest ten amounts in that column in sheet2 to get the amounts description but this formula in side column in sheet1 =IF(ISNUMBER(A1),INDEX('sheet2'!$A$1:$A$55,SMALL(IF('sheet2'!$A$1:$A$55=A1,ROW('sheet2'!$A$1:$A$55)-ROW('sheet2'!$A$1)+1),COUNTIF($A1,A1),"") -you can repeat it to get any information belong to the amount in the other sheet
You can use a combination of VLOOKUP and LARGE(array,k) function, where:
array : column or row of data you want to analyze.
k : the nth order of the item you want.
like for example, to get the4th largest number of a column use, large(array,4).
You can use k from1 to10 to obtain top ten values, and then use Vlookup to look up these values and correspond its equal from the table.
OR YOU CAN SELECT ALL DATA TO MAKE ALIST THEN PRESS CTRL+ SHIFT +L
AND SORT COLUMN OF MOUNTS DESCENDING
THE FIRST TOP10 MOUNTS WILL BE THE TOP TEN
please click on the photo and see onther way FQ : 
I guess you can use DATA - FILTER.
If you have your list in column B in column A add the rank for this list use formula (RANK(B4,$B$4:$B$R) replace R by the last raw number in your list – the value in column B shouldn’t have any duplicated value- then add in column C the serial from1 to10 then use the formula(VLOOKUP(C6,$A$4:$B$20,2,0)) in column D will give you the top10.
There's The Easy Way , Just Sort Them and Just Take The First Ten !
i appreciate all the answers . but all these ways comes only in the same sheet
i mentioned the way to how make this list in another sheet and without messing with the original data
i use this way in the compilicated files
:)
If you have your list in column B in column A add the rank for this list use formula (RANK(B4,$B$4:$B$R) replace R by the last raw number in your list
