I have a table with 4 columns. Last Name, First Name, Value, and Rank. The Rank column goes from 1 to 10. The Value column uses the Large function and the Rank number to return a value from another sheet. For example, the first row returns the 1st largest value, the second row returns the 2nd largest value, and so on. The First Name column uses the Index function, MATCH function, and the number in the adjacent Value column to display the First Name value associated with it on the other sheet. The problem is, if there are duplicate values in the column, the same name ( first one that appears in the other sheet ) is displayed. The spreadsheet is attached. Navigate to the "Statistics" sheet and the "Top 10 In PIKE Rating" table. Any help is appreciated!
Bookmarks