Alternative to Large Function

Currently I'm using MS-Excel inbuilt, LARGE function to pull numeric data from a column in different sheet.
Formula is

Please Login or Register  to view this content.

Then using INDEX, and MATCH function, i pull corresponding values from same row against the respective column.

Problem : Now having used LARGE function, i've certain cells in column having similar value, (Say 5, occuring 3 times in column), so while using INDEX, and MATCH function, i get corresponding values of rows where first numeric value 5 is found.

How to get all the corresponding values against respective but repetitive value, 5, or is there any alternate to function LARGE?

You can use the RANK function, and build in a tie-break to resolve those multiple occurrences. Chip Pearson shows how here:

http://www.cpearson.com/excel/rank.aspx

Hope this helps.

Pete

Thanks for direction, i will do the homework, and will let u know