I recently posted on this site seeing if anyone could help me with a problem I had with my database of NFL players (luckily, JeteMc was able to help me out with that). In this workbook, there are two sheets: one filled with different metrics for players (i.e. height, weight, 40 yard dash and college production) and another that is used to generate a list of the 5 closest comparisons for each player. Now that I can get a top 5 list, I'm trying to find out how to get that top 5 list to transfer over from that sheet to the sheet filled with the data (titled 'CBs'). For instance, cells AJ2, AK2, AL2, AM2 and AN2 would gather Sherman's 1st, 2nd, 3rd, 4th and 5th closest comparisons from the list on the sheet titled 'CB Comparison'. Looking forward to seeing any suggestions!
Bookmarks