#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
league table [email protected] Excel Worksheet Functions 2 September 22nd 07 02:16 PM
League position change trend chart, how? JS25 Excel Discussion (Misc queries) 1 March 18th 07 03:38 PM
League Schedule Vick Excel Discussion (Misc queries) 1 August 18th 06 12:59 AM
Chart league position Rosie Carey Charts and Charting in Excel 1 January 16th 06 04:52 PM
League Table kathleen.smith10 Excel Worksheet Functions 2 March 28th 05 01:00 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"