Comparison Formula

[MoodoHarajli]

Hello, everyone. I'm an avid user of Excel, and I use it to practice basketball analytics extensively. I have amassed a database of a ton of basketball players within the NBA, and I have a bunch of different metrics and combine information for most of my players. I thought of a new idea to create some sort of formula or use some sort of function within Excel to take the metrics and combine info of a player, look into my entire database, and put the name of another player to compare it to that other player that the Excel database sees as most similar to that player. Basically a sort of "best comparable player" type of function, if that makes any sense. I know this is possible within Excel, because of all the things Excel can do, it's hard for me to believe such a function isn't possible. After a week or two of tweaking around in Excel and looking up endlessly online and trying to figure out how to do this, I've resorted to asking the community to help me out here. Is there any way I could get Excel to look at all the players in my database and compare one specific player to another without having to deal with two separate Excel sheets for this like 99% of Google is telling me to? Any feedback would be greatly appreciated. Thanks in advance to anyone who helps me. If any of you have seen this post, I posted it on another forum like this one. Anyways, any help would be greatly appreciated. Thanks in advance, again.

[leelnich]

Duplicate Thread - please post replies at the following link:
https://www.excelforum.com/excel-for...n-formula.html

[AliGW]

Thread closed.