In worksheet "standings", how do I make excel to auto sort from highest to lowest whenever column F (PCT) changes?
In worksheet "skeds", how to add all scores for specific team in column D and F? for example, I want to sum all scores (D and F) for Minnesota Timberwolves (C and E)?
Possible not using any macros?
For #1, this is not possible without a macro.
For #2, worksheet "standings" J3 copied down
=SUMIF(skeds!$C$2:$E$183,Standings!A3,skeds!$D$2:$F$183)
HTH
Regards, Jeff
got a bit confused, how to apply in the attached sample?
Last edited by jeffreybrown; 10-26-2012 at 11:48 PM.
How's this...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks