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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
League age chart
Assuming that table is in A1:M15, then
=INDEX(M1:M15,MATCH(YEAR(player_birth_date),INDEX( A1:L15,0,MATCH(MONTH(player_birth_date),A1:L1,0)), 0)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brian Kolonia" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
League age chart
Bob, thanks for the response but the chart is on another sheet (sheet 5) How
do I incorporate that into the eq. -Brian "Bob Phillips" wrote: Assuming that table is in A1:M15, then =INDEX(M1:M15,MATCH(YEAR(player_birth_date),INDEX( A1:L15,0,MATCH(MONTH(player_birth_date),A1:L1,0)), 0)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brian Kolonia" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
League age chart
Sorry Bob, I had a brain fart, it just clickled now and I was able to get it
to work. Thank you for the help "Brian Kolonia" wrote: Bob, thanks for the response but the chart is on another sheet (sheet 5) How do I incorporate that into the eq. -Brian "Bob Phillips" wrote: Assuming that table is in A1:M15, then =INDEX(M1:M15,MATCH(YEAR(player_birth_date),INDEX( A1:L15,0,MATCH(MONTH(player_birth_date),A1:L1,0)), 0)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brian Kolonia" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
League age chart
Looking at this it appears that the chart is really unimportant - it appears
that the age is based on how old the child is on May 1st. If this is true In a helper cell - enter the date 5/1/2007 (say cell e1) assuming the birthday is in d2....d2000 in cell e2 enter the equation =datedif(d2,$e$1,"y") HTH; "Brian Kolonia" wrote: 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 age chart | Excel Discussion (Misc queries) | |||
league table | Excel Worksheet Functions | |||
League position change trend chart, how? | Excel Discussion (Misc queries) | |||
Racing League needs help | Excel Discussion (Misc queries) | |||
Chart league position | Charts and Charting in Excel |