Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup question
I have developed some sports spreadsheets that have the schedules for each
team (NBA, MLB and College Basketball). On one sheet I have have the schedule for teams and on another sheet I have the standings (Records (Win/Loss), Average Score, Winning Percentage). On the standing sheet I would like to add a list to track the wins and losses and scoring average for last 10 games and have it automatically update. I can do it manually, but with so many team in each league it would be nice for this info to update automatically. Is there a formula or marco that will do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Tables and Formulas | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
Lookup problem | Excel Worksheet Functions | |||
Lookup Type Question | Excel Worksheet Functions | |||
Formula Question... LookUP | Excel Discussion (Misc queries) |