Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
League age chart
I have a large number of youth base ball players listed in a roster;
Player name birth date john doe 3/5/2001 mike smith 7/31/2001... And an age eligiblality chart on another sheet: Month League Age 5 6 7 8 9 10 11 12 1 2 3 4 2002 2002 2002 2002 2002 2002 2002 2003 2003 2003 2003 2003 5 2001 2001 2001 2001 2001 2001 2001 2001 2002 2002 2002 2002 6 2000 2000 2000 2000 2000 2000 2000 2000 2001 2001 2001 2001 7 1999 1999 1999 1999 1999 1999 1999 1999 2000 2000 2000 2000 8 1998 1998 1998 1998 1998 1998 1998 1998 1999 1999 1999 1999 9 1997 1997 1997 1997 1997 1997 1997 1997 1998 1998 1998 1998 10 1996 1996 1996 1996 1996 1996 1996 1996 1997 1997 1997 1997 11 1995 1995 1995 1995 1995 1995 1995 1995 1996 1996 1996 1996 12 1994 1994 1994 1994 1994 1994 1994 1994 1995 1995 1995 1995 13 1993 1993 1993 1993 1993 1993 1993 1993 1994 1994 1994 1994 14 1992 1992 1992 1992 1992 1992 1992 1992 1993 1993 1993 1993 15 1991 1991 1991 1991 1991 1991 1991 1991 1992 1992 1992 1992 16 1990 1990 1990 1990 1990 1990 1990 1990 1991 1991 1991 1991 17 1989 1989 1989 1989 1989 1989 1989 1989 1990 1990 1990 1990 18 I would like to add a colum that would automaticaly grab the correct age from the chart : Palyer name birth date leauge age john doe 3/5/2001 ? mike smith 7/31/2001 ? Is this easily done? Thank you BJK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
league table | Excel Worksheet Functions | |||
League position change trend chart, how? | Excel Discussion (Misc queries) | |||
League Schedule | Excel Discussion (Misc queries) | |||
Chart league position | Charts and Charting in Excel | |||
League Table | Excel Worksheet Functions |