Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Sorting?????
OK,I am keeping track of my baseball kids stats,each tab represents each game,plus one that is a season total,now what I want to do is when I add new game stats,is it possible for it to automatically sort it according to batting avg,or is that asking to much Thanks -- Bigredno8 ------------------------------------------------------------------------ Bigredno8's Profile: http://www.excelforum.com/member.php...o&userid=17162 View this thread: http://www.excelforum.com/showthread...hreadid=374816 |
#2
|
|||
|
|||
You could enter a formula in a "helper " column, which would *display* the
averages in a sorted manner. You would then have to use something like Vlookup to have the "rest" of the data (names, positions, at bats), follow the displayed averages along the row for each player. Say your averages were in C5 to C29. Try this: =LARGE($C$5:$C$29,ROW(A1)) And copy down. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Bigredno8" wrote in message ... OK,I am keeping track of my baseball kids stats,each tab represents each game,plus one that is a season total,now what I want to do is when I add new game stats,is it possible for it to automatically sort it according to batting avg,or is that asking to much Thanks -- Bigredno8 ------------------------------------------------------------------------ Bigredno8's Profile: http://www.excelforum.com/member.php...o&userid=17162 View this thread: http://www.excelforum.com/showthread...hreadid=374816 |
#3
|
|||
|
|||
Bigredno8 Wrote: OK,I am keeping track of my baseball kids stats,each tab represents each game,plus one that is a season total,now what I want to do is when I add new game stats,is it possible for it to automatically sort it according to batting avg,or is that asking to much Thanks Go to http://www.cpearson.com/excel/rank.htm for an excellent explanation (with examples) on ranking. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=374816 |
#4
|
|||
|
|||
Thanks for the replies,I will try them and let you know how it turns out Thanks again Steve -- Bigredno8 ------------------------------------------------------------------------ Bigredno8's Profile: http://www.excelforum.com/member.php...o&userid=17162 View this thread: http://www.excelforum.com/showthread...hreadid=374816 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
find automatic page breaks | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) | |||
Automatic Sorting of a group of columns. | Excel Worksheet Functions |