http://www.getmanyhits.com/baseball-bats-custom/
 |
No items matching your keywords were found.
Microsoft Excel functioning help!?
I am trying to make a custom made baseball score book in Excel. I am attempting to make the last of the many worksheets I have created a leader board. What formula can I use to automatically show who has the highest number in a certain category? Essentially I want cells in one worksheet to automatically display the name of another worksheet based off numerical values. Sorry if this is a difficult question, but I want it to look like:
Batting Average: (Name automatically updated) (amount)
ERA:
Total Ks:
etc:
I already figured out how to do max and mins.
Thanks a lot!!
For the max and min values, my function reads: =Max(Steve!C67,Jon!C67, Shawn!C67,Mike!C67,Nick!C67)
How can I set a function to say who of those 5 has the max or min?
You can incorporate the Max function into an Index/Match formula.
For example, assuming your players are listed in column A and batting averages in column B, the following formula in C1 will return the name of the player with the highest average:
=INDEX(A:A,MATCH(MAX(B:B),B:B,0))
For the batting average, in D1, enter the formula:
=Max(B:B)
How we make Baseball Bats by Superior Bat Company. http://www.promaplebats.com